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

263 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
kains9612564(None) 
ains46158881_ains
cains75334301cains
gains65729511gains
kaifs125715641kaifs
kails95525211kails
kain85334291kain_
kaons95014851kaons
karns96624141karns
kins85747911k_ins
mains75635111mains
pains75138281pains
rains55140231rains
sains55639971sains
tains54936321tains
wains86930871wains
aids57846362_aids
ails45654712_ails
aims67738182_aims
ain37579092_ain_
airns55521032_airns
airs46447422_airs
ais39083572_ai_s
aits46355532_aits
akin86328032akin_
amins75534322amins
anis45746462_anis
awns75324432_awns
ayins85321612ayins
bails75933522bails
bairns86710872bairns
baits76630582baits
banns75321232banns
bans66555142ba_ns
barns76335142barns
basins85722762basins
bins66548252_bins
blains84516372blains
brains85125472brains
brins75533972brins
cabins104418922cabins
caids85226422caids
cain65643912cain_
cairns85313302cairns
cans65050852ca_ns
carns75937562carns
chains114819702chains
chins105631462chins
coins75834552coins
dais57040702dai_s
damns84916922damns
dans56748152da_ns
darns66927892darns
dawns95916592dawns
dins56652042_dins
djins1368452djins
drains73719402drains
earns55927562earns
elains64919852elains
fagins10513862fagins
fails85631482fails
fain75840562fain_
faint85837062faint
faints94818782faints
fairs85825442fairs
fans76247372fa_ns
fauns84516752fauns
fawns115914262fawns
fins75849092_fins
foins85523382foins
gain56042162gain_
gainst74914702gainst
gaits65726012gaits
gamins94420052gamins
gins55543952_gins
grains74223092grains
grins65427222grins
haiks125120932haiks
hails85231642hails
haint85436322haint
haints94417582haints
hairs86225172hairs
hins76447992_hins
ins35945602__ins
jails125422942jails
jins115635012_jins
joins125818412joins
kaas86531842ka_as
kabs107130842ka_bs
kadis105921062kadis
kaes85734062ka_es
kafirs13306982kafirs
kafs116423742ka_fs
kagus105812032kagus
kaiak8310352kaiak
kaiaks937042kaiaks
kaif116933932kai_f
kail85131492kai_l
kainit10414482kainit
kainits1137762kainits
kakas85117342kakas
kakis86116842kakis
kales95730982kales
kalians11310182kalians
kalifs134410982kalifs
kames115024692kames
kamiks11387912kamiks
kamsins1346962kamsins
kana85928532ka_na
kanas95326912kanas
kane85133972ka_ne
kanes95529372kanes
kaolins1139362kaolins
kaon87521022kaon_
kapas116021732kapas
kaphs144911502kaphs
karn86129412karn_
karts97630112karts
kas77058582ka__s
katas95922092katas
kations114013662kations
kats85944332ka_ts
kavas125919952kavas
kayos127714702kayos
kays116032192ka_ys
keens95721182keens
keirs95313672keirs
kens85435232k_ens
kerns94719562kerns
khans124615172khans
khis117017982khi_s
kiang104811352kiang
kiangs11378362kiangs
kids96029642k_ids
kifs116023512k_ifs
kilns95112982kilns
kin76353972k_in_
kina85632002k_ina
kinas95626912k_inas
kind96128562k_ind
kinds106221822k_inds
kine85643432k_ine
kines95039132k_ines
king95933662k_ing
kings105825562k_ings
kinins104014582kinins
kink76034402k_ink
kinks84926082k_inks
kino86233622k_ino
kinos96626142k_inos
kips106430522k_ips
kirns95315452kirns
kirs85831742k_irs
kis78051482k_i_s
kiss85227402k_iss
kits86441772k_its
kliks8398822kliks
knits93914742knits
koans95818622koans
koine9516482koine
koines10415732koines
kois85129402koi_s
kraits104912202kraits
kris86423602kri_s
laics76419252laics
lain46146282lain_
lairs55425872lairs
lapins84520682lapins
lawns85215422lawns
layins93817652layins
lins47059052_lins
loins56728422loins
maids86327142maids
mails76037782mails
maims96321792maims
main65345522main_
mairs76228302mairs
mans66354552ma_ns
matins84527782matins
mavins115119182mavins
naans55815252naans
naifs87617422naifs
nails55730402nails
nans46139402na_ns
paiks114719852paiks
pails75833062pails
pain65647242pain_
paint75443692paint
paints85921832paints
pairs75325832pairs
pans65855732pa_ns
patins87528782patins
pavins114919662pavins
pawns108818132pawns
peins76128062peins
pians75126962pians
pins65558452_pins
plains85019592plains
pyins105815862pyins
qaids156116312qaids
quins144819852quins
raias54631122raias
raids65827512raids
rails55937402rails
rain46251732rain_
rainy85921082rainy
rais45252622rai_s
ranis55235832ranis
ravins94622562ravins
rawins95617622rawins
reins56234562reins
rins46153192_rins
ruins55822032ruins
sabins85521982sabins
saids65328852saids
sails55738102sails
sain45551292sain_
saint55147072saint
saints65122422saints
sans45153362sa_ns
sarins63932622sarins
sasins64923102sasins
satins64930482satins
savins93923132savins
shins85131042shins
sins46755272_sins
skeins103911902skeins
skins94723462skins
spins75327982spins
stains64923652stains
swains94513952swains
tails55634192tails
tain45548072tain_
taint55542282taint
taints64520532taints
takins105117402takins
tans46154822ta_ns
tarns56433952tarns
thins85826332thins
tins45251302_tins
trains64725342trains
twains95811182twains
twins85118982twins
vails85825932vails
vain75233002vain_
vairs85019132vairs
vans76236732va_ns
veins84620492veins
waifs115719872waifs
wails86631482wails
wain75840202wain_
wairs86424062wairs
waits88333522waits
wans76452272wa_ns
warns87231002warns
whins114922332whins
wins75949172_wins
yarns85621792yarns
yawns114213272yawns
yins75335122_yins
zayins18409712zayins
zeins144715392zeins
zins135735002_zins

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.313570897.8
2DLD Change Limit538002631.54634799.5
3Display Results2632630.0803287.5
 (SQL Overall)1786912631.93992156.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.