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

235 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
chemist14361500(None) 
chemise143211501chemise
chemism16339301chemism
chemists152710321chemists
chymist17268171chymist
alchemist1645922alchemist
bemist105216962_bemist
chamisa14328852chamisa
chamise143612852chamise
chamiso14348652chamiso
chemic153012092chemi_c
chemics16349582chemics
chemises153211982chemises
chemisms17278212chemisms
chemistry1944432chemistry
chemos13311722chemos_
cherish15310462cherish
chest104926142che__st
cheviot1546932cheviot
chewiest16177292chewiest
chutist1239452chutist
chymists18285602chymists
coexist1638582coexist
cosmist11311332cosmist
heist87030912_he_ist
theist9314762the_ist
ageist7315383age_ist
alchemists1744543alchemists
animist93815173animist
atheist10314063athe_ist
atomist92915763atomist
bemists113410703_bemists
bemixt174510363_bemixt
biochemist1955033biochemist
blemish1436603blemish
calmest11312343calmest
cambist13312113cambist
camisa103114323c_amisa
camise103319633c_amise
casuist9411303casuist
catmint11314463catmint
cedis84317083c_edis_
cellist9314423cellist
cement103321673c_ement
ceramist12310933ceramist
cerise84822043c_erise
chais107530313ch_ais_
chaise114916413ch_aise
chamisas15317813chamisas
chamises153513313chamises
chamisos15307423chamisos
chamois143512193chamois_
champs154915683champs_
chams126028503cham_s_
chariest13315513chariest
chariot12316213chariot
charism14712203charism
chartist131112133chartist
cheapest1536073cheapest
cheapish1844333cheapish
cheaps134613683cheaps_
cheat105732453che__at
cheats114519543cheats_
checklist2043853checklist
checks174912703checks_
chedite1338863chedite
cheekiest1835703cheekiest
cheeks154712783cheeks_
cheeps135312913cheeps_
cheeriest1438213cheeriest
cheers114518913cheers_
cheese113812763che_ese
cheesiest1436323cheesiest
cheesy14419193che_esy
chefing16359033chefing
chefs136214663che_fs_
chelas113817203chelas_
chemical1748393chemical
chemisette1752573chemisette
chemisorb1853413chemisorb
chemo12313633chem__o
chemostat1655483chemostat
cheroot12413693cheroot
chert105232103che__rt
chertiest1438793chertiest
cherts115617233cherts_
chess105016923che__ss
chestiest1438313chestiest
chests114916263che__sts
chesty144610503che__sty
cheths14389823cheths_
chevied16357483chevied
chevies153511443chevies
cheviots1643783cheviots
chevret153310633chevret
chewier1537593chewier
chewing163911143chewing
chewink19315113chewink
chews135418513che_ws_
chicest14209943chicest
chiefest1645313chiefest
chiliast13117933chiliast
chilis115517873chilis_
chimbs153910303chimbs_
chimes134922573chimes_
chiming153311833chiming
chimps155713663chimps_
chis95933313ch__is_
chit96937463ch__i_t
chits105424573ch__its
chokiest1738723chokiest
chomps155112223chomps_
chrism13710673ch_rism
christy1536623ch_risty
chromiest1637783chromiest
chummiest1834643chummiest
chumps154313823chumps_
chums125015833chum_s_
chutists1335583chutists
chymes165912153chymes_
chymic18317883chymi_c
chymics19295533chymics
cist67244973c___ist
cladist10311973cladist
clement11313773clement
clerisy1246823clerisy
clevis1158963clevis_
coedit9316243coedi_t
coedits10310243coedits
coempt12311033coem_pt
coempts1335683coempts
coexists1735653coexists
commit124016703commi_t
commits133812383commits
commixt20357623commixt
consist9316033consist
copyist1439053copyist
cosmism1337013cosmism
cosmists1237993cosmists
creamiest13248933creamiest
credit9315193credi_t
credits1039973credits
cremes104517993cremes_
cremini11229063cremini
crepiest12310383crepiest
crest74632693cre__st
cubist104214443c_ubist
cultist91412713cultist
cyclist1438853cyclist
cyesis1148573cyesis_
czarist18710223czarist
deist64633593_de_ist
delist74625053_delist
demast9517063_demast
demise94618323_demise
demit84832303_demi_t
demits94918073_demits
desist74818813_desist
duelist8511413duelist
elegist81311973elegist
elemis8312383elemis_
emit65438423__emi_t
emits75421473__emits
epeeist938863epeeist
euphemist16126473euphemist
exist124618943__exist
feist86230073_fe_ist
flemish1536373flemish
geochemist1854983geochemist
gnomist1049133gnomist
heimish1535463_heimish
heists96814633_he_ists
heliast10312073_heliast
hemes105031083_hemes_
hemic125718623_hemi_c
hemin103620933_hemi_n
hemins113417573_hemins
hempiest1539043_hempiest
hemps126917333_hemps_
hems95534943_hem_s_
heriot9422343_heriot
hermit11519443_hermi_t
hermits12312143_hermits
hest75950773_he__st
hist76551553_h__ist
hoist86433213_h_oist
holist94723213_holist
homiest124116633_homiest
hymnist1546633_hymnist
itemise997453itemise
legist71315253_legist
mist66154543___mist
neist54628443_ne_ist
oghamist1444753oghamist
palmist112814343palmist
pietist9414033pietist
plenist9314333plenist
polemist12412363polemist
premise113818553premise
premiss113513813premiss
premixt183510663premixt
querist16311133querist
reemit8717223reemi_t
reemits9611303reemits
relist64628413_relist
remint85329983_remint
remise84221953_remise
remiss84216353_remiss
remit75737223_remi_t
remits85622943_remits
remixt155014853_remixt
resist64524533_resist
rhemes115913183rhemes_
rheumiest1442863rheumiest
schemas1468163schemas_
schemes1489663schemes_
scheming1636633scheming
schist11312653sch__ist
semis74623533_semis_
sexist133013483_sexist
shist84829613sh__ist
theism1139483the_ism
theists1039153the_ists
themes115319253themes_
theming133610473theming
theorist1149553theorist
thermit12312013thermi_t
thermits1338513thermits
thesis94913733thesis_
thewiest14196343thewiest
thymiest1634733thymiest
totemist1049033totemist
verist93823893_verist
wheyish1944063wheyish
whist115322953wh__ist

Search took 7 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.390458182.1
2DLD Change Limit1340272356.43620824.6
3Display Results2352350.0802937.5
 (SQL Overall)1786912356.90625874.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.