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

259 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
thorites1131239(None) 
thorite10313441thorite_
chlorites142311962chlorites
chorines132917252chorines
diorites9313522diorites
horstes104516112_horstes
norites74018802_norites
phorates13413042phorates
shorties11414582shorties
sorites73825242_sorites
tenorites9311092tenorites
theories11311592theori_es
theorises1247812theorises
theorizes2147072theorizes
thermites1438042thermites
thirties1139722thirties
thoraces13118942thoraces
thoraxes1896362thoraxes
thorias102312052thori_as
thoriums13166402thoriums
thorpes125010352thor_pes
thrives134611712th_rives
tories65435882t_ori_es
tortes64826052t_or_tes
aconites10314353aconites
amosites10311233amosites
anchorites1547753anchorites
aphorises14310003aphorises
aphorizes2348013aphorizes
attrites8311563attrites
authorises1347583authorises
authorities1446333authorities
authorizes2247003authorizes
azurites1737283azurites
barites94322333_barites
biotites10310083biotites
boites84322703_bo_ites
borates94823013_borates
borides10515153_borides
bornites10310983_bornites
cerites94823433_cerites
charities14312743charities
chedites1438263chedites
chlorates142512273chlorates
chlorides15289753chlorides
chlorines142512353chlorines
chlorite133012843chlorite_
choices142010613cho_ices
cholates132414763cholates
cholines132214493cholines
chondrites1644763chondrites
chopines152711733chopines
chorales133712883chorales
chordates1547683chordates
chores114828023chor__es
chorine123218363chorine_
chorions13310663chorions
chorister1487143chorister
choristers1586103choristers
chorizos2245493chorizos
chorten122811303chor_ten
chortens13308793chor_tens
chortles133611323chortles
choruses1339983choruses
chromites16310963chromites
cordites11314623_cordites
cowrites133011593cowrites
cuprites1259023cuprites
curites93919863_curites
dhooties1237643dhooties
diorite8314913diorite_
dories75232363_dori_es
ebonites1039233ebonites
ephorates1459163ephorates
etherizes2149313etherizes
ethoxies1845703ethoxi_es
eucrites1049483eucrites
favorites1546583favorites
ferrites112312833ferrites
fluorites1257163fluorites
fomites123613203_fomites
fortes95327183_for_tes
forties104323863_forties
frites94922483__frites
glories81915913glori_es
halites103221193_halites
hogties112813993_hogties
hoises94823673_ho_ises
holies94630033_holi_es
homies114524723_homi_es
homines123518643_homines
hoplites13310543_hoplites
hordes104921633_hor_des
hornets104113553_hornets
hornitos1145393_hornitos
horses94729343_hor_ses
horste94817413_horste_
horsts95817513_horst_s
hotties103016963_hotties
inosites8312793inosites
iolites73819483_iolites
ivories10310713ivori_es
laborites1149253laborites
lories64933043_lori_es
lorises73918593_lorises
meteorites1247613meteorites
niobites1037313niobites
nitrites82313453nitrites
norite63221133_norite_
odorizes1837213odorizes
oolites72817843_oolites
orates64328613__orates
phonates13410643phonates
phonies123717513phoni_es
phorate12413363phorate_
picrites121811083picrites
podites103014733_podites
prorates10418073prorates
pyrites12812203_pyrites
rewrites11311063rewrites
rhyolites1545033rhyolites
rites54442553___rites
shores94830413shor__es
shorings12269483shorings
shorted113614403shor_ted
shorten103511413shor_ten
shortens11288993shor_tens
shorter103515503shor_ter
shortest11310783shor_test
shortias1148093shortias
shortie10411343shortie_
shorts95321743shor_t_s
shotes95321913sho__tes
shrikes144412393sh_rikes
shrines104618693sh_rines
shrives134416173sh_rives
somites94219123_somites
sopites93817173_sopites
sorties74126403_sorties
sprites94220333_sprites
stories7324273stori_es
taborines11238983taborines
taconites1148473taconites
tacrines10310563tacrines
tarries73324263tarri_es
taurines8310553taurines
taxites1449673t_axites
tectites1039993tectites
tektites1236613tektites
tenorite8311993tenorite_
teosintes944553teosintes
tephrites1446313tephrites
tergites9310543tergites
termites10313693termites
terries73425633terri_es
terrines82117553terrines
territs72714503territ_s
theines104013233th_eines
thelitis1147513thelitis
theorise1137873theorise_
theorised1344923theorised
theorists1246603theorists
theorize2047073theorize_
theorized2245803theorized
theorizer2144863theorizer
theorizers2243333theorizers
theres96525473ther__es
theriacs1336543theriacs
therians1138313therians
thermes126214613ther_mes
thermite1339033thermite_
thermits1338513thermit_s
thionates12106663thionates
thionines12106973thionines
thirsted1235213thirsted
thirster1135673thirster
thirsters1235233thirsters
thirsts1036243thirst_s
tholeiites1343233tholeiites
tholes94919783tho__les
thoria93012893thori__a
thorianites1453243thorianites
thoric114314043thori__c
thorium12208413thori_um
thorned11479403thor_ned
thornier1135323thornier
thorniest1236483thorniest
thorniness13264343thorniness
thornless1243633thornless
thorns95314103thor__ns
thorons104511913thor_ons
thorpe113610093thor_pe_
thorps113610893thor__ps
thraves13469713th_raves
threes97117323th_r_ees
thrice114311573th_rice_
thrifts1335523th_rifts
thrills10398783th_rills
thrips11299013th_ri_ps
thrive125313223th_rive_
thrived14458183th_rived
thriven13447023th_riven
thriver13479123th_river
thrivers14456823th_rivers
throated1247923throated
throats104612193throat_s
throes97518673th_r_oes
thrones105715843th_rones
throstles1265903throstles
throttles1254353throttles
thuribles1442523thuribles
thurifer1443273thurifer
thurifers1542913thurifers
thymines1635613thymines
thyrses1335023thyr_ses
tillites8312833tillites
titrates82314663titrates
tobies84521023t_obi_es
todies74223553t_odi_es
toiles63923513t_o_iles
toited74016753t_o_ited
toits55327473t_o_it_s
toonies73719883tooni_es
torches123715433t_orches
tores55352673t_or__es
torics85118353t_ori_cs
torques16217513t_orques
torses64727953t_or_ses
tortas64918253t_or_tas
torte55431703t_or_te_
torten65314353t_or_ten
torts56138123t_or_t_s
totes55139683t_o__tes
towies93521193t_owi_es
toxines142912263t_oxines
tribes85119023t__ribes
trices84826333t__rices
tries55742813t__ri_es
trikes105419493t__rikes
trines64132563t__rines
tripes85324873t__ripes
trite54730033t__rite_
triter65120593t__riter
tritest7315273t__ritest
troilites948433troilites
tropines102214923tropines
tsores65113663tsor__es
tsoris63411193tsori__s
turgites937783turgites
verites103822263_verites
whites123919883wh__ites
whores125617103whor__es
whortles14306743whortles
whorts125111433whor_t_s
whosises1435333whosises
witherites1645973witherites
writes94420333__writes
yperites13310153yperites
zeolites1738383zeolites

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622596.58022213.1
3Display Results2592590.1102354.5
 (SQL Overall)1786912597.11025132.3
 
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.