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 “firm” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

188 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
firm9602646(None) 
farm95934541farm
film94828181film
fir66744901fir_
fire76245601fire
firms105217421firms
firn76927511firn
firs76637721firs
form95836871form
affirm1435522affirm
afire86215912afire
aim57858222ai_m
air38058402air_
airn46433842airn
airs46447432airs
airt45757792airt
airy75734162airy
arm58449632_arm
barm86739612barm
berm86732752berm
bird76128332bird
birk106326872birk
birl65830482birl
biro66131222biro
birr66022372birr
brim85629372brim
chirm125317062chirm
cire65836382cire
corm85735382corm
derm76031892derm
dim68146502di_m
diram84419472diram
dire56644152dire
dirk96326842dirk
dirl57430032dirl
dirt55550392dirt
dorm76834632dorm
fair76332522fair_
fairs85825442fairs
fairy115318282fairy
far67762602far_
fard85639062fard
fare76354462fare
farl76338552farl
farms106324962farms
faro76136922faro
fart76860562fart
fem86040732f_em
fer66646122fer_
fere76342232fere
fermi103914162fermi
fern76129322fern
fiar76427342fiar
fiars86720832fiars
fiat76646652fiat
fib86344282fi_b
fibre104812842fibre
fibs96329512fibs
fice95737122fice
fico95824602fico
fid76847702fi_d
fido87726412fido
fids87034752fids
fie67152452fi_e
fief107331372fief
fiery114714792fiery
fife106027712fife
fig76242842fi_g
figs85332652figs
fil65447152fi_l
fila74729142fila
file75446652file
fill75540202fill
filmi105914002filmi
films105617962films
filmy136114042filmy
filo76034292filo
fils75838702fils
filum105015432filum
fin66458042fi_n
find87532612find
fine75147962fine
fink117532132fink
fino76034702fino
fins75849102fins
fiord94313342fiord
fired94829742fired
firer811229252firer
fires85740752fires
firman112211352firman
firmed125411882firmed
firmer114712442firmer
firmly1436662firmly
firns86018542firns
firry115713532firry
first86226122first
firth115819532firth
fisc96819762fisc
fish106926282fish
fist76248432fist
fit66365462fi_t
fits76043472fits
five107629752five
fix136236112fi_x
fixt1410729722fixt
fiz156238772fi_z
fizz157519832fizz
flam96333292flam
flir76422202flir_
flirs85518932flirs
flirt87424752flirt
foam97127172foam
for66952072for_
fora75937392fora
foram105124932foram
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
forme105225992forme
forms105327052forms
fort76456442fort
forum108318762forum
frig85424502frig
frit77044472frit
friz166324342friz
fro65530642f_ro
from96923922from
fry96226502f_ry
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
germ75428962germ
gird65425002gird
girl56226562girl
girn56026872girn
giro55828642giro
girt56646432girt
gorm75529392gorm
grim76929422grim
harm95637802harm
herm95636152herm
him86247672hi_m
hire75538972hire
infirm1137042infirm
ire36943182_ire
irk76426372_irk
ism56322392_ism
jism135514782jism
kir76535692kir_
kirk76221582kirk
kirn87123452kirn
kirs85831752kirs
lira46928692lira
lire47845302lire
liri45128262liri
mim76048432mi_m
mir57046782mir_
mire66748242mire
miri66730382miri
mirk106729512mirk
mirs66940582mirs
miry96326762miry
nim57142962ni_m
norm66429812norm
perm85834632perm
pirn67128382pirn
prim85132202prim
rim56052282ri_m
sim56553152si_m
sir35746682sir_
sire46150422sire
sirs44338342sirs
term66233152term
tire46143362tire
tirl45029932tirl
tiro46832372tiro
trim65329522trim
vim87437032vi_m
virl76224482virl
warm95935682warm
wire75839822wire
wiry106422842wiry
worm96129492worm
yird87018992yird
yirr76513582yirr
ziram163912892ziram

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721880.78338150.7
3Display Results1881880.0464087.0
 (SQL Overall)1786911881.095163188.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.