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

300 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
thieves134690(None) 
thieve1235961thieve_
thieved1434971thieved
achieves1645522achieves
chives144317592chi_ves
grieves1137322grieves
hives116925512_hi_ves
nieves94311292_nieves
sheeves133911952sheeves
shives124921412shi_ves
shrieves14297092shrieves
sieves93216002_sieves
slieves10378962slieves
thebes115914492th_ebes
theines104013232theines
themes115319252th_emes
theres96525472th_eres
theses96517972th_eses
thievery1742562thievery
thievish1743252thievish
thraves13469712thraves
threes97117322thre_es
thrives134611712thrives
trienes74118412trienes
achieve1545023achieve_
achieved1743713achieved
achiever1643843achiever
achievers1743433achievers
athletes1157883athletes
beeves114615043_beeves
believes13449403believes
breves115516423_breves
cheeses123613103cheeses
chevies153511443ch_evies
chevres15379793ch_evres
chicles143512503chicles
chides124620473chi_des
chiefer1536863chiefer
chiefest1645313chiefest
chiefs14509653chie_fs
chields13507483chields
chiels115115933chie_ls
chigoes1338353chigoes
childes134211273childes
chiles115425303chi_les
chilies124218303chilies
chimeres153511303chimeres
chimes134922573chi_mes
chines115029173chi_nes
chirres123812253chirres
chive135117623chi_ve_
chivies153412853chivies
chivvies1954423chivvies
dienes75719903_dienes
dieses75218693_dieses
dives95832403_di_ves
drives105117113dri_ves
ethenes103313873eth_enes
eves76230463___eves
fives116027363_fi_ves
friezes19418913friezes
ghees95215553gh_e_es
gives95324873_gi_ves
grieve1047243grieve_
grieved1235283grieved
griever1136033griever
grievers1255473grievers
haeres94017033_haeres
halves124717093_halves
haves116034873_h_aves
heaves124120303_heaves
hebes105521673_h_ebes
heezes184211643_heezes
helves124316063_helves
hemes105031083_h_emes
heres86245903_h_eres
hexes155123043_h_exes
hides95129423_hi_des
hies74842833_hi__es
hikes125426983_hi_kes
hinges105121023_hinges
hirees95117293_hirees
hires86134343_hi_res
hisses94719353_hisses
hive106029673_hi_ve_
hived125217913_hi_ved
hooves124815483_hooves
jives154820813_ji_ves
keeves133711983_keeves
knives13458553kni_ves
lieges74113443_lieges
lieve86315473_lieve_
liever94611863_liever
lievest1048343_lievest
lives86133193_li_ves
naives94914223nai_ves
neves87021873__neves
nieces84112713_nieces
nieve85613183_nieve_
ogives10367913ogi_ves
olives94313953oli_ves
outthieves1662243outthieves
peeves113814873_peeves
phizes20389133phi_zes
phoebes1435813phoebes
pieces104217273_pieces
reeves94721493_reeves
reives95723043rei_ves
releves103914973releves
relieves114210393relieves
retrieves1265653retrieves
rhemes115913183rh_emes
riever94811653_riever
rievers104311453_rievers
rives85336003_ri_ves
scrieves13387613scrieves
shaves125224933sh_aves
sheaves134412973sheaves
sheeve123412843sheeve_
shelves134112093shelves
shields11538043shields
shiels95418923shie_ls
shiers94921753shie_rs
shies86136553shi__es
shikses14116573shikses
shines95028913shi_nes
shires95225573shi_res
shivas124512413shi_vas
shive114423423shi_ve_
shiver124517373shi_ver
shivers133714833shivers
shivs115018803shi_v_s
shoves124919413sh_oves
shrieve13417683shrieve_
shrieved15276073shrieved
shrives134416173shrives
sieges73816833_sieges
sieve84918843_sieve_
sieved104611443_sieved
skives134113943ski_ves
sleeves103311343sleeves
slieve9359273slieve_
steeves103410903steeves
strives104119373stri_ves
swives123915183swi_ves
tailles72516473tailles
taxemes1635853taxemes
tees45353583t__e_es
teles54536003t__eles
teleses7313123teleses
telexes1438343telexes
tepees84215243tepe_es
thanes94918983th_anes
thebe107515433th_ebe_
thee78039063th_e_e_
thefts12387923th_efts
thegns10547433th_egns
theine94814923theine_
theins95015423th_eins
theirs94610353th_eirs
theisms1237763theisms
theists1039143theists
theme105921733th_eme_
themed125912583th_emed
thens85921833th_e_ns
there87527393th_ere_
thermes126214613thermes
therms115914873th_erms
these86519013th_ese_
thesis94913733th_esis
thesps11448263th_esps
thetas93011573th_etas
thews117416193th_e_ws
thicken16317873thicken
thickens17266413thickens
thicker163611023thicker
thickest17337303thickest
thicket163213073thicket
thickets17287083thickets
thicks154511993thi_cks
thief114516303thi__ef
thieveries1643473thieveries
thieving1535143thieving
thighed1535263thighed
thighs1346623thi_ghs
thills95515383thi_lls
thimbles1536013thimbles
thine85026853thi_ne_
things104914283thi_ngs
thinker143610673thinker
thinkers15308693thinkers
thinks134613353thi_nks
thinned11399153thinned
thinner10358963thinner
thinners11327743thinners
thinness11277153thinness
thinnest11248883thinnest
thins85826323thi__ns
thiols95112763thi_ols
thirams1236803thirams
thirds10438603thi_rds
thirled11328093thirled
thirls95012063thi_rls
thirsts1036243thirsts
thirties1139723thirties
this76027383thi___s
thistles1198233thistles
thither13328103thither
tholes94919783th_oles
thorpes125010353thorpes
thrave126010273thrave_
threads11419953threads
threaps12488643threaps
threats104311673threats
three87526913thre_e_
threep115910113thre_ep
threeps12687043threeps
threshes1437383threshes
thrive125313223thrive_
thrived14458183thrived
thriven13447023thriven
thriver13479123thriver
thrivers14456823thrivers
throes97518673th_roes
thrones105715843thrones
throve128012393throve_
thymes144810743th_ymes
thyrses1335013thyrses
tides64830153t_i_des
tidies74721833t_idies
tieless72512563t_ieless
tierces93710453t_ierces
tiered73613973t_iered
tiers55526523t_ie_rs
ties45248313t_i__es
tikes95628903t_i_kes
tildes74513963t_ildes
tiles55542103t_i_les
times75630823t_i_mes
tines54848423t_i_nes
tinges74722323t_inges
tires55437493t_i_res
tithes94720213t_ithes
titles63719923t_itles
titres64718933t_itres
tmeses85712243t_meses
toiles63923513toi_les
tonemes9311683tonemes
topees85519703tope_es
traves94222743t_raves
trees55835763t_re_es
trevet94818913t_revet
trevets10499973t_revets
triages82613793triages
tribes85119023tri_bes
trices84826333tri_ces
triene64316383triene_
triens65417543trie_ns
trientes82812123trientes
triers64321523trie_rs
tries55742813tri__es
trifles103814823trifles
trikes105419493tri_kes
trines64132563tri_nes
triodes84012503triodes
trioses75015653trioses
tripes85324873tri_pes
triples94616873triples
triremes1035523triremes
trisemes1036643trisemes
triunes74311383triunes
trivet93721883tri_vet
trivets103911583trivets
troves94719113t_roves
tsimmes1133673tsimmes
tuilles72411923tuilles
turves94212693t_urves
tutees6514553tute_es
tuyeres10417793tuyeres
tweezes19345703tweezes
twelves1334303twelves
twiers95410163twie_rs
twines94717273twi_nes
twinges11409443twinges
tyees86019453t_ye_es
tzimmes2033063tzimmes
waives123714183wai_ves
wharves16457133wharves
wheezes22306803wheezes
wheres125917433wh_eres
wherves16548053wherves
whiles124418013whi_les
whines125120103whi_nes
whinges143610623whinges
whishes16309443whishes
whites123919883whi_tes
whities133113253whities
whizzes2134713whizzes
whoever1634103whoever
wives115328923_wi_ves

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.1531167915.0
2DLD Change Limit1340273007.73617325.1
3Display Results3003000.0933225.8
 (SQL Overall)1786913007.98222386.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.