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

355 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
firmest123927(None) 
airest63825262air_est
airiest74221012airiest
dimmest1249252dimmest
direst75024242dir_est
fairest10412292fair_est
ferment12315572ferment
fiercest13216142fiercest
fieriest112112242fieriest
figment1379742figment
filmiest1338552filmiest
filmset1257512filmset
finest94321732fi_nest
fires85740752fir_es_
firmed125411882firme_d
firmer114712442firme_r
firmers124711442firmers
firmness1334742firmness
firms105217422firm_s_
firriest112310432firriest
first86226122fir__st
fitment12710302fitment
fittest102510802fittest
forest94926742for_est
formes114623712formes_
freest95318282f_reest
kirmess13234312kirmess
miriest93619822miriest
mirkest13309722mirkest
warmest123113032warmest
wiriest103816852wiriest
aeriest73924053aeriest
ailment9314233ailment
airless73712043airless
airmen82612353airme_n
airpost939243airpost
aridest8316143aridest
armet76739453_arme_t
armets84918353_armets
armrest9310163_armrest
arrest63722633_arrest
barest85327693bar_est
barmiest125212783barmiest
bermes106023003bermes_
biggest1138143biggest
biomes103815253biomes_
biremes1138773biremes_
birles84920643birles_
birses84717733birses_
bummest13298623bummest
calmest11312343calmest
cermet10321153cerme_t
cermets1139713cermets
chirkest1735383chirkest
cires74932913cir_es_
crest74632693_cr_est
crimes105521583crimes_
curtest9713963curtest
darkest122512623darkest
diciest103316523diciest
digest84019623di_gest
dimes85833043di_mes_
direct93817333dir_ect
dirges84915103dirges_
diriment11410743diriment
dirtiest93014203dirtiest
dismast10311233dismast
dismes95617673dismes_
divest106820073di_vest
drest65530343_dr_est
driest74722753_driest
dryest104811123_dryest
durmast1037623durmast
earnest7318733earnest
eeriest73620673eeriest
fabbest1438033fabbest
fainest10417703fainest
faintest1139073faintest
fairies103516043fairies_
fairness1136563fairness
falsest10310013falsest
fames105735923f_ames_
farces115223323farces_
fares85852873far_es_
farles96025783farles_
farmed125117653farme_d
farmer115017373farme_r
farmers124315263farmers
farms106324953farm_s_
farness102912203farness
farthest1499863farthest
fastest102413723fastest
fattest102913063fattest
featest102715113featest
fellest10313753fellest
femes105626223f_emes_
femmes135410213femmes_
feres86038183fer_es_
ferments13311473ferments
fermis114313503fermis_
ferniest1132214153ferniest
ferret93021173ferre_t
ferrets103111393ferrets
fervent13310063fervent
fest74949443f___est
fewest12311663f_ewest
feyest12311403f_eyest
fibres114312123fibres_
fices106031163fi_ces_
fiches145219533fiches_
ficklest17267903ficklest
ficoes114613463ficoes_
fideist1139753fideist
fidges114114393fidges_
fidget114216483fidge_t
fidgets12388763fidgets
fiesta938123fi__esta
fifes114822393fi_fes_
figments1446943figments
filament13410033filament
filbert12411643filbert
filemot1246703filemot
files85441273fi_les_
filet85540163fi_le_t
filets94718953fi_lets
filles94224523filles_
fillet95027083fille_t
fillets103414753fillets
filmed124610363filme_d
filmer114112403filme_r
filmers124211293filmers
filmis114610283filmis_
filmless1344553filmless
films105617963film_s_
filmsets1353413filmsets
fines86644263fi_nes_
finless102810783finless
finniest113011403finniest
fiques1837973fiques_
fire76245593fir_e__
fired94829743fir_e_d
fireless112810593fireless
firelit10310863firelit
fireman1249333fireman
firemen1238773firemen
firepot1248733firepot
firer811229253fir_e_r
firers94922683fir_ers
firm96026453firm___
firmament1645403firmament
firman112211343firm_an
firmans12238523firmans
firming132811223firming
firmly1436663firm_ly
firns86018543fir_ns_
firs76637713fir__s_
firsts95110923fir__sts
firths125113503firths_
fishes125221343fishes_
fishiest14310453fishiest
fist76248423fi___st
fitments1376793fitments
fitness10299393fitness
fives116027363fi_ves_
fixes154723593fi_xes_
fizzes174512553fizzes_
fizziest19226073fizziest
flames114723693flames_
flamiest133111973flamiest
fliest94718433f_liest
flippest1535173flippest
flirtiest1236193flirtiest
flumes115119733flumes_
foamiest13289853foamiest
foment113718303f_oment
fondest11312403fondest
forces114422133forces_
foremast1348613foremast
foremost1348583foremost
fores85847103for_es_
forests104114953for_ests
forfeit1339203forfeit
forges105024263forges_
forget106326393forge_t
forgets113813793forgets
forkiest153812303forkiest
formant123416003formant
format113021353form_at
formats123113573formats
forme105225993forme__
formed125021173forme_d
formee113919943forme_e
former114221403forme_r
formers128217953formers
formless13248083formless
forms105327053form_s_
fornent10312933fornent
fortes95327183fortes_
forwent13310533forwent
foulest10313313foulest
foxiest174310493foxiest
foziest194110943foziest
frames115119863frames_
frees86131393f_rees_
fresh115012203f_r_esh
fret75845043f_r_e_t
frets85523403f_r_ets
fries85535603f_ries_
friges104116483friges_
frises94124273frises_
frites94922483frites_
frizes184015463frizes_
froes86126693f_roes_
frost84727833f_r_ost
frowst125512073f_rowst
fullest10313343fullest
fumes105224703f_umes_
fumet105630223f_ume_t
fumets114311813f_umets
fumiest12312193fumiest
funest94316863f_unest
funfest13348083funfest
funnest102912003funnest
furies95126373furies_
furless103210143furless
furmenty1645293furmenty
furmety1534813furmety
furriest112910793furriest
furthest1496863furthest
furzes186613693furzes_
furziest20267783furziest
gamest94919923_gamest
garment10315233garment
germiest11249913germiest
gimmes113010903gimmes_
girliest93010403girliest
goriest82218743goriest
grimes94619033grimes_
grimiest11299823grimiest
grimmest13286293grimmest
hairiest11612463hairiest
hardest113118413hardest
harvest132112753harvest
highest1439563highest
hippest14219753hippest
hirees95117293hirees_
hires86134343hir_es_
iciest82914743_iciest
idlest74014863_idlest
iffiest1337963iffiest
illest63615723_illest
immesh1334113_immesh
incest82918743_incest
infest93315433_infest
ingest73119003_ingest
inmesh1134863_inmesh
inmost8411363_inmost
invest93014843_invest
iratest7312483_iratest
ires45639283_ir_es_
jimpest18297553jimpest
jiviest1738113jiviest
kermes124616133kermes_
kermess13396223kermess
kindest12311503kindest
kismet123414623kisme_t
kismets13306883kismets
lamest84722763_lamest
largest83715103largest
liefest1038443liefest
lievest1048343lievest
likest104914383li_kest
limes75636503li_mes_
limiest93716103limiest
limpest113712313limpest
liniest73321153liniest
lithest10513913lithest
livest95315733li_vest
merest84725113mer_est
midmost1246153midmost
mildest102812063mildest
mimes95732023mi_mes_
mires75640883mir_es_
mirkiest142910253mirkiest
mismeet113215163mismeet
mismet103722373misme_t
mitiest93520053mitiest
murkest133110203murkest
nicest82315663ni_cest
nighest11310693nighest
oiliest72817683oiliest
pertest9317043pertest
pigment12510733pigment
piniest93121133piniest
pinkest132812623pinkest
pipiest113114493pipiest
prest75736353_pr_est
priest84125423_priest
primes104225263primes_
primmest14226693primmest
purest84021933pur_est
rarest65725483rar_est
reest54938093__reest
rest46459843__r_est
richest122813683richest
rifest93114583ri_fest
rimes75634543ri_mes_
rimiest93215853rimiest
ripest84317943ri_pest
rummest11279833rummest
sarment9318763sarment
serest64831613ser_est
siamese936503siamese
sickest131813793sickest
sirees64624583sirees_
sires55945373sir_es_
siziest16311473siziest
slimmest1235903slimmest
sorest65028003sor_est
spiriest102513453spiriest
spriest92718643spriest
spryest12247813spryest
surest65026763sur_est
tamest85721293_tamest
tartest72517533tartest
tersest71713993tersest
tidiest83514873tidiest
times75630823ti_mes_
tiniest73020123tiniest
tiredest938403tiredest
tires55437493tir_es_
torment9316173torment
trimmest12227023trimmest
tritest7315273tritest
truest64816193_truest
unrest62918853unr_est
varment12313243varment
veriest103719133veriest
vermes115019143vermes_
vilest9416843vi_lest
viniest103216613viniest
vires84529683vir_es_
wariest105122503wariest
weirdest1244433weirdest
widest104517003wi_dest
wildest113311273wildest
wiliest103416593wiliest
winiest103419693winiest
wires86034913wir_es_
wisest95016443wi_sest
wormiest13249543wormiest
wrest84925433_wr_est
wriest94419713_wriest
wryest12429113_wryest
yarest95018913yar_est

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 Limit1340273555.75023309.0
3Display Results3553550.1262817.5
 (SQL Overall)1786913556.28228444.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.