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

226 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
firn7692751(None) 
airn46433841airn
fern76129321fern
fin66458041fi_n
fir66744901fir_
fire76245601fire
firm96026461firm
firns86018541firns
firs76637721firs
girn56026871girn
kirn87123451kirn
pirn67128381pirn
afire86215912afire
ain37579102ai_n
air38058402air_
airns55521032airns
airs46447432airs
airt45757792airt
airy75734162airy
bairn77515532bairn
barn66444642barn
bin56658652bi_n
bird76128332bird
birk106326872birk
birl65830482birl
biro66131222biro
birr66022372birr
born67338412born
brin67038192brin
burn65636432burn
cairn75717512cairn
carn66245432carn
cion613330922cion
cire65836382cire
corn69945812corn
curn66731892curn
darn56434622darn
din46459472di_n
dire56644152dire
dirk96326842dirk
dirl57430032dirl
dirt55550392dirt
durn56127632durn
earn46737552earn
ern35738362_ern
fain75840562fain
fair76332522fair_
fairs85825442fairs
fairy115318282fairy
fan67158862f_an
far67762602far_
fard85639062fard
fare76354462fare
farl76338552farl
farm95934542farm
faro76136922faro
fart76860562fart
faun76226622faun
fawn105321952fawn
feign94210712feign
fen66851352f_en
fer66646122fer_
fere76342232fere
ferns85220082ferns
ferny115816182ferny
fiar76427342fiar
fiars86720832fiars
fiat76646652fiat
fib86344282fi_b
fibre104812842fibre
fibrin1138532fibrin
fibs96329512fibs
fice95737122fice
ficin103516722ficin
fico95824602fico
fid76847702fi_d
fido87726412fido
fids87034752fids
fie67152452fi_e
fief107331372fief
fiend95312982fiend
fiery114714792fiery
fife106027712fife
fig76242842fi_g
figs85332652figs
fil65447152fi_l
fila74729142fila
file75446652file
fill75540202fill
film94828182film
filo76034292filo
fils75838702fils
find87532612find
fine75147962fine
fink117532132fink
finny114716752finny
fino76034702fino
fins75849102fins
fiord94313342fiord
fired94829742fired
firer811229252firer
fires85740752fires
firing104021722firing
firkin1337822firkin
firman112211352firman
firms105217422firms
firry115713532firry
first86226122first
firth115819532firth
fisc96819762fisc
fish106926282fish
fist76248432fist
fit66365462fi_t
fits76043472fits
five107629752five
fix136236112fi_x
fixt1410729722fixt
fiz156238772fi_z
fizz157519832fizz
flan76134182flan
flir76422202flir_
flirs85518932flirs
flirt87424752flirt
fohn106116552fohn
foin77231562foin
fon66352272f_on
for66952072for_
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
frig85424502frig
frit77044472frit
friz166324342friz
fro65530642f_ro
fry96226502f_ry
fun66841142f_un
fur66637322fur_
furan84320012furan
furl77030882furl
furs76735042furs
fury107727972fury
gien56330032gien
gin46055762gi_n
gird65425002gird
girl56226562girl
girns64516802girns
giro55828642giro
giron66118992giron
girt56646432girt
grin55733722grin
hern76134892hern
hin67559572hi_n
hire75538972hire
hisn79620942hisn
horn76735612horn
in28150872_i_n
inn36727442_inn
ion36051032_ion
ire36943182_ire
irk76426372_irk
iron46728462_iron
jin106443942ji_n
jinn115420252jinn
karn86129432karn
kern85326222kern
kiln85620992kiln
kin76353982ki_n
kir76535692kir_
kirk76221582kirk
kirns95315462kirns
kirs85831752kirs
lien45339812lien
limn66527702limn
lin37967382li_n
linn46034602linn
lion46334452lion
lira46928692lira
lire47845302lire
liri45128262liri
lorn46435252lorn
mien65028372mien
mir57046782mir_
mire66748242mire
miri66730382miri
mirin75023152mirin
mirk106729512mirk
mirs66940582mirs
miry96326762miry
morn66237562morn
pian66136102pian
pin57066732pi_n
pion67235302pion
pirns76020092pirns
porn65636022porn
rin36663192ri_n
sign55523062sign
sin36265902si_n
sir35746682sir_
sire46150422sire
siren54525822siren
sirs44338342sirs
sorn46641062sorn
tarn46842722tarn
tern46134802tern
tin36362182ti_n
tire46143362tire
tirl45029932tirl
tiro46832372tiro
torn46044252torn
turn46330392turn
urn35731472_urn
virl76224482virl
warn75239322warn
win66456302wi_n
wire75839822wire
wiry106422842wiry
worn75631752worn
yarn75230042yarn
yin67648742yi_n
yird87018992yird
yirr76513582yirr
zin125643782zi_n

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.296603685.8
2DLD Change Limit298722260.89033564.0
3Display Results2262260.0633587.3
 (SQL Overall)1786912261.249143067.3
 
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.