Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “distent” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

294 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
distent8412085(None) 
dissent84018681dissent
distant83519951distant
distend93312071distend
descent102616292descent
detent73624482d_etent
diluent8310262diluent
discant103017252discant
discept12310622discept
disject17268672disject
dispend11289412dispend
disseat83816922disseat
dissect103614132dissect
dissents93411862dissents
dissert83720692dissert
distends10339822distends
distinct11410762distinct
distort81120332distort
existent1548262existent
intent63122772_intent
listen64816812listen_
listens74014132listens
missent94318712missent
mistend103812522mistend
stent55634512__stent
wisent93516342wis_ent
absent84016993abs_ent
ailment9314233ailment
ascent84519653_ascent
assent65119953_assent
attent62818323_attent
bisect10312873bis_ect
bister84922763biste_r
bisters93922613bisters
bistort91216523bistort
bitten84715123bitten_
cisted95217523ciste_d
cistern93310703cistern
cisterna10376363cisterna
cisterns10369573cisterns
content94326153content
daftest11248943daftest
decent94023703d_ecent
deftest112611713deftest
dehiscent1545483dehiscent
dement93825143d_ement
dent57158413d___ent
descant104315583descant
descend11248153descend
descents112511203descents
desert72725493des_ert
desinent9312963desinent
dessert82916453dessert
destine83719953destine
destiny113111463destiny
detect94217403d_etect
detente83313603d_etente
detents83615153d_etents
detest74122843d_etest
dialect101210263dialect
diastem10318043diaste_m
diastema11264743diastema
diastems11226523diastems
diaster82813313diaste_r
diasters92913183diasters
diciest103316523diciest
dickens144410133dickens
dictiest113212783dictiest
diene65720133di__ene
diester83013683dieste_r
diesters92513603diesters
diet57357533di__e_t
dieted83115493diete_d
dieter73516773diete_r
dieters83216433dieters
dieting93616833dieting
digest84019623di_gest
diktat11310693dikt_at
dilatant948203dilatant
diligent1048033diligent
diluents946053diluents
dimmest1249253dimmest
dint56759053di___nt
dinted84419843dinte_d
dinting93520553dinting
diplont10311693diplont
dipnet91317473dipne_t
diptera1037213diptera
direct93817333di_rect
direst75024243di_rest
diriment11410743diriment
dirtiest93014203dirtiest
disband1138243disband
discants112912023discants
disced104914653disce_d
discepts1336743discepts
discern1038493discern
discerns1138163discerns
discing113914593discing
discontent13410253discontent
discount11811313discount
discreet11413183discreet
diseur738843dis_eur
disgust937633disgust
dished114318713dishe_d
dishelm1335833dishelm
disherit12412523disherit
dishes104622653dishe_s
dishiest12313683dishiest
dishing124017103dishing
disjects18275923disjects
disjoint1649233disjoint
disjunct1843963disjunct
disked125015763diske_d
diskette1346753diskette
disking134615493disking
dismast10311233dismast
disme85716243disme__
dismes95617673disme_s
dismount1188223dismount
disorient10412523disorient
disown1036953disown_
disowns1136733disowns
dispart101115283dispart
dispel9310323dispe_l
dispels10310503dispels
dispends12308533dispends
dispense11129783dispense
displant11412223displant
disport101015953disport
disputant1245743disputant
disroot8413563disroot
disrupt1048633disrupt
disseats93211503disseats
dissects11279243dissects
dissed85220183disse_d
dissented1199723dissented
dissenter1059133dissenter
disserts92411813disserts
disses75225963disse_s
dissident1147693dissident
dissing94517683dissing
distaff1467683distaff
distain8313783distain
distains9413603distains
distal73615773dist_al
distance11311853distance
distantly1346393distantly
distaste939943distaste
distended12157923distended
distender11167743distender
distention11158873distention
distich13312173distich
distil73616433dist_il
distill83011323distill
distils83015803distils
distome10313233distome
distorts91112353distorts
distract11313023distract
distraint101112903distraint
distrait9414343distrait
distress9311713distress
district11413873district
distrust949943distrust
disturb1046233disturb
dite55547553di_te__
dites66339153di_te_s
ditsiest92111323ditsiest
dittany1135653dittany
divalent1247783divalent
divert103922813di_vert
divest106820073di_vest
divestment16146313divestment
dizen155214933di_zen_
dizens164911393di_zens
docent92918683d_ocent
dusted83918373duste_d
duster74919723duste_r
dusters84918363dusters
dustiest93015073dustiest
dusting93618993dusting
dustmen1035773dustmen_
existents1644983existents
extent132714913_extent
fasten95114893fasten_
fastens105511753fastens
fastest102413723fastest
figment1379743figment
fishnet13410343fishnet
fisted104218703fiste_d
fisting113818123fisting
fitment12710303fitment
fittest102510803fittest
glisten8418083glisten_
glistens9366593glistens
hasten95718563hasten_
hastens106214813hastens
histed104420243histe_d
histing113720373histing
histone10312843histone
incent83320723_incent
indent73021243_indent
insistent948253insistent
instant7815343instant
intend72310373_intend
intents72115703_intents
invent93316363_invent
islet54527553_isle_t
justest1449893justest
kismet123414623kisme_t
kitten104611483kitten_
kittens11347583kittens
latent64124303_latent
lisente71210703lis_ente
listed74322833liste_d
listee64223063liste_e
listees73416673listees
listel64214743liste_l
listels74212433listels
listened9168813listened
listener8158313listener
lister64527253liste_r
listers74026533listers
listing84020593listing
litten64014873litten_
misagent11410723misagent
miseat82925703mis_eat
misevent1349223misevent
miskept1538923miskept
mismeet113215163mismeet
mismet103722373misme_t
mispen10312173mispen_
mispens11311073mispens
misseat93617233misseat
missend104411373missend
misset85028153misse_t
misspent1259173misspent
misted93625823miste_d
mistends11419593mistends
mister84728563miste_r
misterm114314513misterm
misters93927513misters
misteuk1335893misteuk
mistiest103018313mistiest
misting103623383misting
mistreat10313113mistreat
mistune9310653mistune
mitten83914093mitten_
mittens9349883mittens
moisten93110143moisten_
moistens10268773moistens
moistest1038763moistest
mostest9314793mostest
nascent9610523nascent
ointment1069233ointment
patent84524923_patent
pigment12510733pigment
pissant91012503pissant
piste75824603piste__
pistes85325633piste_s
piston83515923piston_
pistons93016373pistons
portent93619643portent
potent84223353_potent
resent63833623res_ent
rident7520193ri_dent
ringent8315153ringent
risen54621883ris_en_
scent75831623__scent
sent46963013__s_ent
sestet6826203seste_t
shent85933503__shent
silent64125843si_lent
sister64421583siste_r
sisters73721593sisters
sitten64113823sitten_
spent75532833__spent
steno54716863__steno
stents65019453__stents
stet45947323__ste_t
stint57037663__stint
stunt55328173__stunt
tent46159863___tent
unsent63820963uns_ent
unspent92610893unspent
upsent83314063ups_ent
vastest102911513vastest
vestment13109203vestment
violent102110813violent
visitant1147363visitant
wisents10249063wis_ents
wisest95016443wis_est
wisted104120273wiste_d
wisting113519743wisting

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1401276364.3
2DLD Change Limit1340272946.93619323.4
3Display Results2942940.1102672.7
 (SQL Overall)1786912947.18624866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.