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

298 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
ferrite10331275(None) 
ferrate103014041ferrate
ferrites112312831ferrites
cerite84724872ce_rite
febrile1237152febrile
feirie939552feiri_e
felsite1039082felsite
feriae95618602fe_riae
ferine96422582fe_rine
ferity122813342fe_rity
ferlie92814052ferli_e
fermate122813002fermate
ferrates113013422ferrates
ferret93021172ferret_
ferreted1236332ferreted
ferreter1136542ferreter
ferrets103111392ferrets
ferrety13287012ferrety
ferriage1245462ferriage
ferric1139992ferri_c
ferried113411522ferried
ferries103521082ferries
ferritic1347072ferritic
ferritin1147382ferritin
ferrule1035862ferrule
fertile10311732fertile
forrit91916622forrit_
kernite1159472kernite
perlite9317322perlite
rewrite10311142rewrite
serrate73017542serrate
tergite8311002tergite
termite9313892termite
terrine72517572terrine
territ63421372territ_
territs72714502territs
verite94323442ve_rite
aerate64830553ae_rate
aerie54634603ae_ri_e
aerolite8315053aerolite
afebrile1342683afebrile
arenite71017713arenite
arrive91311793_arrive
attrite7311833attrite
azurite1638003azurite
barite84224813_barite
becrime1387053becrime
begrime1276553begrime
berate84729023be_rate
berime105317333be_rime
berline93716853berline
berried103714043berried
berries94423553berries
bornite9311183bornite
burkite1337003burkite
burrito936223burrito
cerate84829463ce_rate
cerise84822043ce_rise
cerites94823433ce_rites
cerusite1047763cerusite
cervine122610803cervine
cirrate92413493cirrate
cordite10315263cordite
corrie83621223corri_e
cowrite123612683cowrite
cuprite1159683cuprite
curite85222943_curite
currie84317263curri_e
dearie73319813deari_e
debride1138593debride
dendrite1048783dendrite
deprive1338303deprive
derate74531233de_rate
deride84420033de_ride
derive103817043de_rive
derrick1435803derrick
derriere936043derriere
derries83124623derries
derris73615273derri_s
derrises93012783derrises
despite10410123despite
diorite8314913diorite
durrie73713263durri_e
eerie55228533_eeri_e
elite56230183_e_lite
endite73817593_endite
eremite9312833_eremite
ergate7315143_ergate
ermine8416923_ermine
errata639013_errata
errhine1036593_errhine
erring73816483_erring
erudite838483_erudite
eucrite939903eucrite
evite85317683_e_vite
excite15310883_excite
eyrie88117833_eyri_e
faerie93514683faeri_e
farcie114816473farci_e
farrier103514893farrier
farside1138603farside
favorite1447313favorite
fearing113520033fearing
federate12310883federate
feline94820143fe_line
fellate10313433fellate
felsites1138073felsites
feracity1646733feracity
fere76342233fe_r__e
feria85922713fe_ri_a
ferial94621253fe_rial
ferias95020393fe_rias
ferities111416713fe_rities
ferlies103216693ferlies
fermata12278143fermata
fermi103914163fermi__
fermion1236763fermion
fermis114313503fermi_s
fermium1446353fermium
fernier103110823fernier
fernlike1535243fernlike
ferocity1645993ferocity
ferrel92810203ferr_el
ferreled1234843ferreled
ferrels10248623ferrels
ferreters1246253ferreters
ferriages1345663ferriages
ferritins1247273ferritins
ferrotype17233623ferrotype
ferrous1049793ferrous
ferruled1263923ferruled
ferrules1136163ferrules
ferrum1147453ferr_um
ferrums1265983ferrums
ferry116020803ferr__y
ferrying15146243ferrying
ferrymen1643943ferrymen
ferulae10309603ferulae
ferule93413203fe_rule
fervid1337513fervi_d
festive1339773festive
fete75734923fe___te
feterita1166463feterita
finite9316823f_inite
firrier103410133firrier
fleabite1354163fleabite
flite85424963f__lite
fluorite1147893fluorite
fomite113314073f_omite
forgive1436193forgive
formate123115093formate
forte86131463f_or_te
fraise94214913f_raise
freewrite1543603freewrite
frere85617723frer__e
frise85322453f__rise
frit77044473f__rit_
frites94922483f__rites
frith115922033f__rith
frits86129103f__rits
fritt86129413f__ritt
fritz176020773f__ritz
fruit85122223f_ruit_
fruited11389093f_ruited
fruiter10309683f_ruiter
fruits94512493f_ruits
fruity12429693f_ruity
furcate12310453furcate
furmity1535183furmity
furrier103513663furrier
furrily1337613furrily
furriner11267303furriner
furring114013143furring
furtive1337173furtive
garrote8510103garrote
hermit11519443hermit_
hermits12312143hermits
herniae1039043herniae
herniate1148113herniate
heroine103517483heroine
heroize193210963heroize
herried113514453herried
herries104025073herries
herring113615883herring
hessite1038993hessite
jerrid14259143jerri_d
jerrids15277743jerrids
jerries143817513jerries
kernites1269113kernites
kerria10339913kerri_a
kerrias11289513kerrias
kerries113317913kerries
lenite6719983le_nite
leucite937753leucite
marlite92917073marlite
marmite112413993marmite
merit7339183me_rit_
merited10313853me_rited
merits8320873me_rits
merrier92612303merrier
merrily1238633merrily
murrine9411483murrine
narrate7313493narrate
nephrite1346713nephrite
nervate1039533nervate
nervine102510633nervine
neurine7311683neurine
nitrite72314463nitrite
norite63221133_norite
orrice81410163_orrice
overbite13312083overbite
overrate11615693overrate
override121512523override
overrife14169933overrife
overripe131410383overripe
overwrite1579083overwrite
partite9317133partite
pearlite1039443pearlite
peerie83617893peeri_e
pelite84323003pe_lite
penlite9313243penlite
perdie94718513perdi_e
periti8319953pe_riti
perlites10316363perlites
permit10321683permit_
permits11314003permits
permute1138793permute
perorate10417923perorate
perries93226603perries
petite84320653pe_tite
picrite111911313picrite
pyrite11913313_pyrite
recite83625113re_cite
recrate92621663recrate
redrive112410563redrive
regrate82618663regrate
reprice113212833reprice
reprise92715043reprise
requite162012483requite
reraise7316313reraise
rerise64325633re_rise
reroute7313963reroute
resite64128453re_site
respite9513033respite
reunite7312713reunite
rewriter1137923rewriter
rewrites11311063rewrites
rewrote1039123rewrote
rite45849453___rite
secrete9311073secrete
seriate73722473seriate
serine65432673se_rine
serrated92513433serrated
serrates82617023serrates
serried82513963serried
serries73925353serries
service1239093service
servile10310643servile
sprite84421773_sprite
sternite8310543sternite
tectite9310583tectite
tektite1136883tektite
tenorite8311993tenorite
tephrite1346593tephrite
terete6319333te_rete
tergites9310543tergites
termites10313693termites
ternate7415483ternate
terrace93311843terrace
terrae62915213terr_ae
terrane72814233terrane
terrene72411033terrene
terret63425623terret_
terrets72913583terrets
terrible1046643terrible
terrier73414963terrier
terries73425633terries
terrify1336353terrify
terrines82117553terrines
thermite1339033thermite
thorite10313443thorite
trite54730033__trite
turgite837973turgite
verbile1249863verbile
verditer1236223verditer
verites103822263ve_rites
verity123714853ve_rity
versine102515173versine
verste94515633ve_rste
website1235323website
wernerite1245173wernerite
worrit92313313worrit_
worrited1235743worrited
worrits10258683worrits
write85522833__write
yperite1249893yperite
zebrine1836463zebrine
zeolite1638903zeolite

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272986.48320673.6
3Display Results2982980.1102709.1
 (SQL Overall)1786912986.99925530.9
 
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.