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

331 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
ferrites11231283(None) 
ferrates113013421ferrates
ferries103521081ferri_es
ferrite103312751ferrite_
berries94423552berri_es
cerites94823432ce_rites
derries83124622derri_es
derrises93012782derrises
felsites1138072felsites
ferities111416712fe_rities
ferlies103216692ferli_es
ferrate103014042ferrate_
ferreted1236332ferreted
ferreter1136542ferreter
ferreters1246252ferreters
ferrets103111392ferret_s
ferriages1345662ferriages
ferried113411522ferri_ed
ferritic1347072ferritic
ferritin1147382ferritin
ferritins1247272ferritins
ferrules1136162ferrules
frites94922482f__rites
herries104025072herri_es
jerries143817512jerri_es
kernites1269112kernites
kerries113317912kerri_es
perlites10316362perlites
perries93226602perri_es
rewrites11311062rewrites
serrates82617022serrates
serries73925352serri_es
tergites9310542tergites
termites10313692termites
terries73425632terri_es
terrines82117552terrines
territs72714502territ_s
verites103822262ve_rites
aerates74627493ae_rates
aeries64737783ae_ri_es
aerolites9312583aerolites
arenites8917103arenites
arrises71617583_arrises
arrives101311513_arrives
attrites8311563attrites
azurites1737283azurites
barites94322333_barites
becrimes1467073becrimes
begrimes1376513begrimes
berates94126873be_rates
berimes115216643be_rimes
berlines102315453berlines
berried103714043berri_ed
bornites10310983bornites
burkites1436673burkites
burritos1044473burritos
carries94328013carri_es
cerastes101111093cerastes
cerates95428253ce_rates
cercises12410933cercises
cerises94722253ce_rises
cerite84724873ce_rite_
certes84623083ce_r_tes
cerusites1146523cerusites
cervices1537133cervices
cervixes2054603cervixes
cherries131812983cherri_es
cordites11314623cordites
corries94026793corri_es
cowrites133011593cowrites
cuprites1259023cuprites
curites93919863_curites
curries93723163curri_es
dearies83526273deari_es
debrides1268723debrides
decries103319803decri_es
dendrites1147933dendrites
deprives1438393deprives
derates84028893de_rates
derbies103016053derbi_es
derides93420853de_rides
derives114017813de_rives
dermises112512023dermises
derricks1544433derricks
derrieres1044813derrieres
derris73615273derri__s
despites11410313despites
detritus945473detritus
diorites9313523diorites
durries83817353durri_es
elites66027123_e_lites
endites83717063_endites
equites162212493_equites
eremites10312603_eremites
ergates8314493_ergates
ermines9416673_ermines
erratas736863_erratas
errhines1136413_errhines
eucrites1049483eucrites
evites94916473_e_vites
excites16310633_excites
eyries93816813_eyri_es
faeries104118993faeri_es
fairies103516043fairi_es
farcies125317883farci_es
farrier103514893farri_er
farriers113610743farriers
farsides1237993farsides
favorites1546583favorites
fealties1139993fealties
febrile1237153febrile_
federates13310153federates
feirie939553feiri_e_
felines104718073fe_lines
fellates11312753fellates
fellies104119743felli_es
felsite1039083felsite_
feracities1548713feracities
feres86038183fe_r__es
feriae95618603fe_riae_
ferias95020393fe_ri_as
ferine96422583fe_rine_
ferity122813343fe_rit_y
ferlie92814053ferli_e_
fermatas13246223fermatas
fermate122813003fermate_
fermions1336203fermions
fermis114313503fermi__s
fermiums1544353fermiums
ferneries1239043ferneri_es
fernier103110823ferni_er
ferniest1132214153ferni_est
ferocities1548243ferocities
ferrel92810203ferr__el
ferreled1234843ferreled
ferrels10248623ferr_els
ferreous1146033ferreous
ferret93021173ferr__et
ferrety13287013ferret_y
ferriage1245463ferriage
ferric1139993ferri__c
ferrotypes18263673ferrotypes
ferrous1049793ferr_ous
ferrule1035863ferrule_
ferruled1263923ferruled
ferrums1265983ferr_ums
ferrymen1643943ferrymen
fertile10311733fertile_
ferules103112723fe_rules
feteritas1264893feteritas
fetes85630143fe___tes
finites10315923f_inites
firrier103410133firri_er
firriest112310433firri_est
fleabites1443613fleabites
flites95122443f__lites
fluorites1257163fluorites
flurries11188913flurri_es
fomites123613203f_omites
forcipes1535943forcipes
forgives1535753forgives
formates132814293formates
fornices1369103fornices
forrit91916623forrit__
fortes95327183f_or_tes
forties104323863forti_es
fraises104215693f_raises
freewrites1643573freewrites
fremitus1344023fremitus
freres94716173frer__es
fries85535603f__ri_es
friges104116483f__riges
frises94124273f__rises
friths124313583f__riths
frits86129103f__rit_s
fritts94613193f__ritts
fritzes19329453f__ritzes
frizes184015463f__rizes
frontes104214163f_rontes
fruited11389093f_ruited
fruiter10309683f_ruiter
fruiters11328183f_ruiters
fruits94512493f_ruit_s
furcates1339883furcates
furies95126373f_uri_es
furmities1447543furmities
furrier103513663furri_er
furriers11369493furriers
furriest112910793furri_est
furriner11267303furriner
furriners12316323furriners
furriness12287603furriness
furrings12317143furrings
garrotes969363garrotes
gurries83515953gurri_es
harries103525493harri_es
hearties11315413hearties
henries102718283henri_es
hermits12312143hermit_s
herniates1247333herniates
heroines112916573heroines
heroizes202610983heroizes
herried113514453herri_ed
herrings12379533herrings
hessites1138613hessites
hurries103919653hurri_es
jerkies183411583jerki_es
jerrids15277743jerri_ds
kermises14248313kermises
kernite1159473kernite_
kerrias11289513kerri_as
lenites7818443le_nites
leucites1037333leucites
lorries74518343lorri_es
marlites103415263marlites
marmites122212793marmites
marries93825283marri_es
mercies113817563merci_es
merises93421423me_rises
merited10313853me_rited
merits8320873me_rit_s
merrier92612303merri_er
merriest10311473merri_est
merriness1138293merriness
metritis1049183metritis
morrises10711073morrises
murries94118673murri_es
narrates8312763narrates
nephrites1446503nephrites
nereides938503nereides
nervines112310463nervines
neurines8311193neurines
neuritis848493neuritis
nitrites82313453nitrites
norites74018803_norites
orrices9129363_orrices
orrises71312233_orrises
overbites14310983overbites
overrates12414623overrates
overrides131411013overrides
overwrites1658113overwrites
parries93925843parri_es
pearlites1138233pearlites
peeries93623023peeri_es
pelites93821993pe_lites
penlites10312273penlites
peritus9311803pe_ritus
perlite9317323perlite_
permits11314003permit_s
permutes1238713permutes
perorates11417023perorates
petites93820203pe_tites
picrites121811083picrites
pyrites12812203_pyrites
recites93524583re_cites
recrates102420373recrates
redries83721713redri_es
redrives122610393redrives
refries104419733refri_es
regrates92618403regrates
reprices122913353reprices
reprises102615463reprises
requites171511763requites
reraises8415643reraises
rerises73525883re_rises
reroutes8312223reroutes
resites74027793re_sites
respites10513243respites
retries74129073retri_es
reunites8312473reunites
rewrite10311143rewrite_
rewriter1137923rewriter
rewriters1236343rewriters
rites54442553___rites
secretes10410473secretes
seriates82620673seriates
series64540973se_ri_es
serines74229543se_rines
serrate73017543serrate_
serrated92513433serrated
serried82513963serri_ed
services1338573services
sherries111812893sherri_es
sherrises12156863sherrises
skerries12168673skerri_es
sorites73825243_sorites
sprites94220333_sprites
sternites9310073sternites
tarries73324263tarri_es
tectites1039993tectites
tektites1236613tektites
tenorites9311093tenorites
tephrites1446313tephrites
tergite8311003tergite_
termite9313893termite_
terraces102712253terraces
terranes82514433terranes
terrases82111483terrases
terrenes82212603terrenes
terrets72913583terret_s
terrier73414963terri_er
terriers84210823terriers
terrifies12139723terrifies
terrine72517573terrine_
territ63421373territ__
thermites1438043thermites
thorites11312393thorites
turgites937783turgites
veeries102916893veeri_es
velites103417303ve_lites
verbiles1338923verbiles
verditer1236223verditer
verditers1344993verditers
veritas103012753ve_ritas
verite94323443ve_rite_
verities111418043ve_rities
vernixes1836053vernixes
versines112213823versines
verstes104014283ve_rstes
vertices13612283vertices
wearies103020223weari_es
websites1335183websites
wernerites1344943wernerites
wherries14179023wherri_es
worries104117133worri_es
worrited1235743worrited
worrits10258683worrit_s
writes94420333__writes
yperites13310153yperites
zebrines1935883zebrines
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.406440125.6
2DLD Change Limit1461623316.83021400.0
3Display Results3313310.1232691.1
 (SQL Overall)1786913317.35924282.0
 
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.