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
fins75849091fi_ns
fires85740751fires
firms105217421firms
firn76927501firn_
firs76637711fir_s
girns64516801girns
kirns95315451kirns
pirns76020091pirns
ains46158882ai_ns
airn46433832airn_
airs46447422air_s
airts55626342airts
bairns86710872bairns
barns76335142barns
bins66548252bi_ns
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
brins75533972brins
burns74926772burns
cairns85313302cairns
carns75937562carns
cions75222852cions
cires74932912cires
corns76034762corns
curns74924272curns
darns66927892darns
dins56652042di_ns
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
durns64819862durns
earns55927562earns
erns45428222_erns
fairs85825442fair_s
fans76247362f_ans
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fauns84516752fauns
fawns115914262fawns
feigns10407752feigns
fens76139762f_ens
feres86038182feres
fern76129322fern_
ferny115816182ferny
fiars86720832fiars
fiats85324482fiats
fibres114312122fibres
fibrins1238632fibrins
fibs96329502fi_bs
fices106031162fices
ficins113513982ficins
ficus105015492ficus
fidos95819052fidos
fids87034732fi_ds
fiefs116213702fiefs
fiend95312982fiend
fiends104110292fiends
fifes114822392fifes
figs85332642fi_gs
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fi_ls
fin66458032fi_n_
find87532602fi_nd
finds95424822finds
fine75147952fi_ne
fines86644262fines
finis86824262finis
fink117532122fi_nk
finks125424222finks
finny114716752finny
fino76034692fi_no
finos86226952finos
fiords10498622fiords
fir66744892fir__
fire76245592fir_e
fired94829742fired
firer811229252firer
firers94922682firers
firing104021722firing
firings114112322firings
firkins1437662firkins
firm96026452fir_m
firmans12238522firmans
firry115713532firry
first86226122first
firsts95110922firsts
firth115819532firth
firths125113502firths
fiscs105311882fiscs
fists85527542fists
fits76043462fi_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
gins55543952gi_ns
girds74816992girds
girls64518392girls
girn56026862girn_
girons75014372girons
giros65722652giros
girts65423622girts
grins65427222grins
herns84825582herns
hins76447992hi_ns
hires86134342hires
horns86125332horns
inns46920932_inns
ins35945602_i_ns
ions46737852_ions
ires45639282_ires
iris45732552_iris
irks86220132_irks
irons55324132_irons
jinns126013842jinns
jins115635012ji_ns
karns96624142karns
kerns94719562kerns
kilns95112982kilns
kins85747902ki_ns
kirks84915262kirks
kirn87123432kirn_
kirs85831732kir_s
liens56525502liens
limns75718392limns
linns56123332linns
lins47059052li_ns
lions55923212lions
liras56021982liras
miens76118302miens
mires75640882mires
mirins83918902mirins
mirks115122142mirks
mirs66940572mir_s
morns75527442morns
pians75126962pians
pins65558452pi_ns
pions75826392pions
pirn67128372pirn_
porns75527342porns
rins46153192ri_ns
signs65516322signs
sins46755272si_ns
sirens65318152sirens
sires55945372sires
sirs44338332sir_s
sorns55028412sorns
tarns56433952tarns
terns55226872terns
tins45251302ti_ns
tires55437492tires
tirls54519802tirls
tiros54524892tiros
turns55623232turns
urns46323892_urns
vires84529682vires
virls85618602virls
virus85316842virus
warns87231002warns
wins75949172wi_ns
wires86034912wires
yarns85621792yarns
yins75335122yi_ns
yirds96612512yirds
yirrs8469192yirrs
zins135735002zi_ns

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 Filter178691538000.0961861364.6
2DLD Change Limit538001971.56334421.0
3Display Results1971970.0603283.3
 (SQL Overall)1786911971.719103950.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.