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 “kestrel” 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.

183 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
kestrel113711(None) 
kestrels1235811kestrels
bestrew1248002bestrew
costrel9310372costrel
estral64716512_estral
petrel83111532pe_trel
peytrel1264252peytrel
vestral104111012vestral
wastrel1037552wastrel
astral66919283_astral
austral73411513austral
beshrew1554393beshrew
bested94922763best_ed
bestial9311643bestial
bestrewn1343333bestrewn
bestrews1335603bestrews
bestrid1039973bestrid
bestrow1237253bestrow
betel74419903be_t_el
bethel1169643be_thel
bistre83815023bistre_
bistred103311853bistred
bistres94017213bistres
central93114473central
centre84316643centre_
centred103411683centred
centres93817123centres
coistrel1046743coistrel
costrels1038933costrels
desire7415303desire_
desired9311983desired
desirer8310783desirer
desires81316133desires
destrier9311823destrier
destroy1138153destroy
dextral1577003dextral
dottrel834463dottrel
entree61817883_entree
esteem838813_esteem
ester54727713_est_er
esters64627733_esters
estray95713333_estray
estreat7314813_estreat
estrin6315923_estrin
estriol747553_estriol
estrual7367933_estrual
estrum81810513_estrum
estrus61912113_estrus
ferrel92810203fe_rrel
festal94213563fest_al
fester94723513fest_er
festered122512113festered
festers104121393festers
gastral8329553gastral
gastrea847243gastrea
genteel836753genteel
geste65920693gest_e_
gestes75721393gest_es
gestural946033gestural
gesture839243gesture_
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
hostel93914153host_el
jested144416503jest_ed
jester134319153jest_er
jesters144118193jesters
jestful1745333jestful
keel85729473ke___el
keester11319913keest_er
keesters12319593keesters
keister113011573keist_er
keisters123212043keisters
kelter103214383kelt_er
kelters113813753kelters
kennel10369223ke_nnel
kente95821073kent_e_
kentes105118653kent_es
kernel104010593ke_rnel
ketol95414003ke_t_ol
kettle104311613kettle_
kettles113411613kettles
kevel124213103ke__vel
keyster14256153keyst_er
keysters15326333keysters
kiester11329973kiest_er
kiesters123310153kiesters
kistful1465303kistful
kittel10368873k_ittel
listel64214743list_el
lustral7339653lustral
lustre64011683lustre_
lustred8359053lustred
lustres73013233lustres
mestee84523883mest_ee
mestees94617753mestees
metre74821303me_tre_
metred95315143me_tred
metres85121563me_tres
minstrel1046913minstrel
mistral91013643mistral
nested74720063nest_ed
nester64124183nest_er
nesters74422793nesters
nestle63013953nestle_
nestled8349913nestled
nestler73510453nestler
nestles73015463nestles
neutral737923neutral
nostril749303nostril
oestrin7312243oestrin
oestriol845383oestriol
oestrum9177783oestrum
oestrus7169583oestrus
pastel85918713past_el
pester84827593pest_er
pestered112814973pestered
pesterer102412713pesterer
pesters93827093pesters
pestier94317403pestier
pestle83215843pestle_
pestled102711453pestled
pestles93217693pestles
petrels9279373pe_trels
petrol82714063pe_trol
peytral1287503peytral
peytrels1363373peytrels
poitrel936193poitrel
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restful1038623restful
restoral8810983restoral
restore75822983restore_
restored96417193restored
restorer84813723restorer
restores85222993restores
restress82511773restress
restyle1038763restyle
retral64419743re_tral
rostral7311333rostral
sestet6826203sest_et
sorel56231443__sorel
steel55721993__steel
streel64214023__streel
strep77120853__strep
strew89220663__strew
testae64216253testae_
tested74421523test_ed
testee64323303test_ee
testees74215913testees
tester64227153test_er
testers74124543testers
testes65125823test_es
testier74015643testier
tetryl935693te_tryl
unsteel738793unsteel
ventral103612173ventral
vessel937953ves_sel
vestal94615573vest_al
vested104217353vest_ed
vestee94319153vest_ee
vestees103513173vestees
vestries11314053vestries
vestry1238623vestr_y
vestural1156473vestural
vesture10310373vesture_
vestured1237463vestured
vestures11311043vestures
wastrels1136203wastrels
wester94222893west_er
westered122511873westered
westerly1445553westerly
western102911103western
westers105221963westers
yester93417983yest_er
yestern10338643yestern
yestreen1144603yestreen
zested164214043zest_ed
zester153617793zest_er
zesters163517293zesters
zestful1945243zestful
zestier163010223zestier

Search took 9 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.453394461.4
2DLD Change Limit1340271837.50017870.3
3Display Results1831830.0762407.9
 (SQL Overall)1786911838.02922255.7
 
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.