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

206 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
theisms123776(None) 
atheisms1346921atheisms
theism1139481theism_
theists1039151theists
ageisms1056602ageisms
atheism1248522atheism_
atheists1138712atheists
chemisms17278212chemisms
chrisms1499142chrisms
deisms94411042_deisms
ditheisms1544892ditheisms
heists96814632_heists
seisms84912142_seisms
thairms1244452thairms
theines104013232theines
theins95015422thei_ns
theirs94610352thei_rs
theist9314762theis_t
therms115914872the_rms
theses96517972the_ses
thesis94913732the_sis
thesps11448262the_sps
truisms9106822truisms
ableisms1245413ableisms
ageism968803ageism_
ageists848493ageists
agisms9399393_agisms
atavisms1346993atavisms
atheist10314063atheis_t
atomisms12269573atomisms
autisms94311553autisms
chaises124317493chaises
charisms15710263charisms
chasms135513143ch_asms
cheeses123613103cheeses
chemises153211983chemises
chemism16339303chemism_
chemists152710323chemists
chess105016923che_s_s
chesses124112633chesses
chests114916263che_sts
chiasms14357523chiasms
chirms135113983ch_irms
chrism13710673chrism_
chrisma1456823chrisma
chrisoms1566093chrisoms
civisms1436073civisms
cubisms13306883cubisms
deism84116033_deism_
deists74916433_deists
ditheism1446053ditheism_
ditheists1345573ditheists
echoisms1546143echoisms
egoisms1065953egoisms
eonisms92811043eonisms
etatisms1038293etatisms
favisms1535443favisms
feists94915313_feists
fideisms1444453fideisms
gneiss765953gneis_s
heils85222193_hei_ls
heirs85618563_hei_rs
heishi1235843_heishi
heist87030913_heis_t
heliums12188303_heliums
helms105619463_he_lms
hems95534943_he__ms
herms105626433_he_rms
heroisms1338693_heroisms
hests85829933_he_sts
hims95230973_h_i_ms
hiss75629213_h_is_s
hists86328373_h_ists
hoises94823673_hoises
hoists95516023_hoists
holisms123811113holisms
iodisms10308483iodisms
isms66213473___isms
jisms14458003__jisms
lyrisms1235653lyrisms
momisms10308223momisms
monisms113512803monisms
mutisms11338453mutisms
nanisms938833nanisms
nomisms11268743nomisms
nudisms10305853nudisms
obelisms1236393obelisms
obiisms1135673obiisms
ogreisms1144113ogreisms
ogrisms1036443ogrisms
pantheisms1745073pantheisms
papisms13238543papisms
peises84125043_peises
phenoms1437813phenoms
pietisms1247463pietisms
plenisms1237963plenisms
porisms113713453porisms
prisms104915503_prisms
purisms114110833purisms
racisms112310813racisms
rheniums1344413rheniums
rhesus936203rhe_sus
rheums1135463rhe_ums
sadisms10359113sadisms
schisms1437173schisms
seises64026713_seises
seism75019023_seism_
sexisms16226223sexisms
sheikhs17233993sheikhs
sheiks132510013shei_ks
sheilas1059403sheilas
shims104422553sh_i_ms
shists96515113sh_ists
speises93813933speises
speiss84311643speis_s
statisms1039543statisms
tachisms1567143tachisms
tamises92715973tamises
tanists7313653tanists
tapises92914013tapises
teams75726513t_e_ams
teases65426273t_eases
tediums10266973tediums
teems76019783t_e_ems
teiids736693t_eiids
teinds738263t_einds
tenses64722553t_enses
terms75523473t_e_rms
tests56530193t_e_sts
thairm1156963thairm_
tharms115712243th_arms
thebes115914493the_bes
thefts12387923the_fts
thegns10547433the_gns
thein85919023thei__n
theine94814923thei_ne
their85512153thei__r
theistic1348153theistic
thelitis1147513thelitis
them97427043the__m_
theme105921733the__me
themes115319253the_mes
thenars10248523thenars
thens85921833the__ns
theorems1344693theorems
theorises1247813theorises
theorists1246603theorists
theres96525473the_res
theriacs1336543theriacs
therians1138313therians
therm106018023the_rm_
therme115814993the_rme
thermes126214613thermes
thermos124610753thermos
these86519013the_s_e
thesp105410313the_s_p
thetas93011573the_tas
thews117416193the__ws
thicks154511993th_icks
thieves1346903thieves
thighs1346633th_ighs
thills95515383th_ills
things104914303th_ings
thinks134613363th_inks
thins85826333th_i_ns
thiols95112763th_iols
thirams1236823thirams
thirds10438603th_irds
thirls95012063th_irls
thirsts1036243thirsts
this76027383th_i__s
thoriums13166403thoriums
thrifts1335523thrifts
thrills10398783thrills
thrips11299013thri_ps
thrives134611713thrives
thrums11429123th_rums
thrusts10226523thrusts
thuliums1343553thuliums
thyrses1335023thyrses
thyrsus1342693thyrsus
tmeses85712243tme_ses
tmesis8529793tme_sis
tokenisms1544453tokenisms
totemisms1344913totemisms
tourisms1037613tourisms
tress55423163tre_s_s
tresses73719543tresses
trims75021473t_ri_ms
trismus935563t_rismus
tritheisms1543943tritheisms
tropisms1247723tropisms
truism8118623truism_
tsarisms1056653tsarisms
tsetses785453tsetses
tubists9288323tubists
twists9549753t_wists
typists1236173typists
tzarisms1965213tzarisms
utopisms1245413utopisms
verisms123011253verisms
whelms14377573whe_lms
whims134515333wh_i_ms
whisks16497353wh_isks
whists124613813wh_ists
wholisms1665253wholisms

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.406440125.6
2DLD Change Limit1340272065.98322401.3
3Display Results2062060.0633269.8
 (SQL Overall)1786912066.45227695.4
 
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.