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

197 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
firns8601854(None) 
airns55521031airns
ferns85220081ferns
fins75849101fi_ns
fires85740751fires
firms105217421firms
firn76927511firn_
firs76637721fir_s
girns64516801girns
kirns95315461kirns
pirns76020091pirns
ains46158892ai_ns
airn46433842airn_
airs46447432air_s
airts55626342airts
bairns86710872bairns
barns76335142barns
bins66548262bi_ns
birds85421342birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
brins75533972brins
burns74926782burns
cairns85313302cairns
carns75937562carns
cions75222852cions
cires74932912cires
corns76034762corns
curns74924282curns
darns66927892darns
dins56652052di_ns
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
durns64819872durns
earns55927562earns
erns45428232_erns
fairs85825442fair_s
fans76247372f_ans
fards96629842fards
fares85852872fares
farls85731112farls
farms106324962farms
faros85532022faros
farts88336842farts
fauns84516752fauns
fawns115914262fawns
feigns10407752feigns
fens76139762f_ens
feres86038182feres
fern76129322fern_
ferny115816182ferny
fiars86720832fiars
fiats85324482fiats
fibres114312122fibres
fibrins1238642fibrins
fibs96329512fi_bs
fices106031162fices
ficins113513982ficins
ficus105015492ficus
fidos95819062fidos
fids87034752fi_ds
fiefs116213702fiefs
fiend95312982fiend
fiends104110292fiends
fifes114822392fifes
figs85332652fi_gs
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838702fi_ls
fin66458042fi_n_
find87532612fi_nd
finds95424832finds
fine75147962fi_ne
fines86644262fines
finis86824262finis
fink117532132fi_nk
finks125424222finks
finny114716752finny
fino76034702fi_no
finos86226952finos
fiords10498622fiords
fir66744902fir__
fire76245602fir_e
fired94829742fired
firer811229252firer
firers94922682firers
firing104021722firing
firings114112332firings
firkins1437662firkins
firm96026462fir_m
firmans12238522firmans
firry115713532firry
first86226122first
firsts95110922firsts
firth115819532firth
firths125113502firths
fiscs105311882fiscs
fists85527542fists
fits76043472fi_ts
fives116027362fives
fixes154723592fixes
flans85327972flans
flirs85518932flir_s
flirts95411482flirts
fohns117310782fohns
foins85523382foins
fons76943892f_ons
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
fries85535602fries
frigs96019272frigs
frits86129102frits
frons86124042frons
funs75235732f_uns
furans94515952furans
furls85322052furls
furs76735042fur_s
gins55543962gi_ns
girds74817002girds
girls64518392girls
girn56026872girn_
girons75014372girons
giros65722652giros
girts65423622girts
grins65427222grins
herns84825582herns
hins76448002hi_ns
hires86134342hires
horns86125332horns
inns46920932_inns
ins35945612_i_ns
ions46737852_ions
ires45639282_ires
iris45732552_iris
irks86220132_irks
irons55324132_irons
jinns126013842jinns
jins115635022ji_ns
karns96624152karns
kerns94719562kerns
kilns95112992kilns
kins85747922ki_ns
kirks84915272kirks
kirn87123452kirn_
kirs85831752kir_s
liens56525502liens
limns75718392limns
linns56123332linns
lins47059062li_ns
lions55923212lions
liras56021982liras
miens76118302miens
mires75640882mires
mirins83918902mirins
mirks115122142mirks
mirs66940582mir_s
morns75527442morns
pians75126962pians
pins65558462pi_ns
pions75826392pions
pirn67128382pirn_
porns75527342porns
rins46153202ri_ns
signs65516322signs
sins46755282si_ns
sirens65318152sirens
sires55945372sires
sirs44338342sir_s
sorns55028422sorns
tarns56433952tarns
terns55226872terns
tins45251312ti_ns
tires55437492tires
tirls54519802tirls
tiros54524892tiros
turns55623242turns
urns46323902_urns
vires84529682vires
virls85618602virls
virus85316842virus
warns87231002warns
wins75949182wi_ns
wires86034912wires
yarns85621792yarns
yins75335132yi_ns
yirds96612522yirds
yirrs8469192yirrs
zins135735012zi_ns

Search took 6 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 Filter178691538001.126158695.4
2DLD Change Limit538001974.28012570.1
3Display Results1971970.0464282.6
 (SQL Overall)1786911975.45232775.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.