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

155 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
kilns9511298(None) 
kills94526171kills
kiln85620981kiln_
kilos95021471kilos
kilts95122181kilts
kins85747911ki_ns
kirns95315451kirns
ails45654712ail_s
ains46158882ai_ns
airns55521032airns
biles75542142biles
bilks115117892bilks
bills75632862bills
bins66548252bi_ns
cions75222852cions
dills65530972dills
dins56652042di_ns
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
fins75849092fi_ns
firns86018542firns
gilds75417522gilds
gills64728192gills
gilts64924262gilts
gins55543952gi_ns
girns64516802girns
hills85431352hills
hilts86924412hilts
hilus84817642hilus
hins76447992hi_ns
ikons96311012ikons
ilks87218572_ilks
ills47030422_ills
inns46920932_inns
ins35945602_i_ns
ions46737852_ions
jills125122822jills
jilts124717412jilts
jinns126013842jinns
jins115635012ji_ns
kails95525212kail_s
kains96125642kains
kales95730982kales
kaons95014852kaons
karns96624142karns
keens95721182keens
kelps115116422kelps
kelts95222632kelts
kens85435232k_ens
kerns94719562kerns
khans124615172khans
kiang104811352kiang
kiangs11378362kiangs
kibes115521112kibes
kiblas1239322kiblas
kicks104420082kicks
kids96029642ki_ds
kiefs126112202kiefs
kiers95320092kiers
kifs116023512ki_fs
kikes85122552kikes
kilim11711892kilim
kilims1277902kilims
kill85533182kil_l
kilned11368392kilned
kilo86028672kil_o
kilt86144422kil_t
kilty125213892kilty
kin76353972ki_n_
kina85632002ki_na
kinas95626912kinas
kind96128562ki_nd
kinds106221822kinds
kine85643432ki_ne
kines95039132kines
king95933662ki_ng
kings105825562kings
kinins104014582kinins
kink76034402ki_nk
kinks84926082kinks
kino86233622ki_no
kinos96626142kinos
kips106430522ki_ps
kirks84915262kirks
kirn87123442kirn_
kirs85831742ki_rs
kis78051482ki__s
kiss85227402ki_ss
kists95822112kists
kites95432542kites
kiths125814972kiths
kits86441772ki_ts
kivas124614732kivas
kiwis12328582kiwis
kliks8398822kliks
koans95818622koans
kolas94822232kolas
kolos94921212kolos
krills104211282krills
liens56525502liens
lilos55821872lilos
lilts55822802lilts
limns75718392limns
linns56123332linns
lins47059052li_ns
lions55923212lions
miens76118302miens
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045332mil_s
milts75430712milts
nills54926672nills
nils46132452nil_s
oils46337972oil_s
pians75126962pians
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pins65558452pi_ns
pions75826392pions
pirns76020092pirns
riles55343642riles
rills55032712rills
rins46153192ri_ns
signs65516322signs
silds65520522silds
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
sins46755272si_ns
skills104313922skills
skins94723462ski_ns
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
tins45251302ti_ns
vills86429322vills
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
wins75949172wi_ns
yills83921552yills
yins75335122yi_ns
zills144020782zills
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.296603685.8
2DLD Change Limit538001551.50035866.7
3Display Results1551550.0305166.7
 (SQL Overall)1786911551.82697859.3
 
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.