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

202 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
kinds10622183(None) 
binds86627481binds
finds95424831finds
hinds96721481hinds
kids96029651ki_ds
kinas95626921kinas
kind96128571kind_
kines95039141kines
kings105825571kings
kinks84926091kinks
kinos96626151kinos
kins85747921kin_s
minds85427131minds
rinds64826151rinds
winds95425611winds
aids57846372ai_ds
ains46158892ain_s
ands57833622_ands
bands85233432bands
bends85628972bends
bids75838462bi_ds
bind76234522bind_
bindi85617022bindi
bindis94614582bindis
bines76946792bines
bins66548262bin_s
bints76130182bints
birds85421342birds
blinds95111612blinds
bonds86126842bonds
bunds85523542bunds
cines75239682cines
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652052din_s
dints67431312dints
ends56528532_ends
fends96324972fends
fids87034752fi_ds
fiends104110292fiends
find87532612find_
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849102fin_s
fonds95824822fonds
funds94119252funds
gids65933752gi_ds
gilds75417532gilds
ginks104319562ginks
gins55543962gin_s
girds74817002girds
grinds84511842grinds
hands95327382hands
hind85529762hind_
hins76448002hin_s
hints87330622hints
ids47535482_i_ds
inks86926502_inks
inns46920932_inns
ins35945612_in_s
jinks165019332jinks
jinns126013842jinns
jins115635022jin_s
kains96125652kain_s
kanas95326922kanas
kanes95529372kanes
kendo105113232kendo
kendos114510662kendos
kenos95220622kenos
kens85435252ken_s
kiangs11378362kiangs
kibes115521122kibes
kicks104420092kicks
kid86540632ki_d_
kiddo11398962kiddo
kiddos12416872kiddos
kiddy144910292kiddy
kiefs126112212kiefs
kiers95320102kiers
kifs116023522ki_fs
kikes85122562kikes
kills94526182kills
kilns95112992kilns
kilos95021482kilos
kilts95122192kilts
kin76353982kin__
kina85632012kin_a
kinase104210652kinase
kinder113716852kinder
kindest12311502kindest
kindle114414242kindle
kindles123614842kindles
kindly14358852kindly
kine85643442kin_e
king95933672kin_g
kinin94917332kinin
kinins104014582kinins
kink76034412kin_k
kinky115816392kinky
kino86233632kin_o
kips106430532ki_ps
kirks84915272kirks
kirns95315462kirns
kirs85831752ki_rs
kis78051492ki__s
kiss85227412ki_ss
kists95822122kists
kites95432552kites
kiths125814982kiths
kits86441782ki_ts
kivas124614742kivas
kiwis12328592kiwis
knits93914752knits
koines10415732koines
konks84917112konks
lands65426902lands
lends65326252lends
lids56336472li_ds
lindy96918322lindy
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059062lin_s
lints57137192lints
mends84927692mends
mids76541802mi_ds
milds86422062milds
minas75434112minas
mind75434392mind_
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
nines55937342nines
oinks94819912oinks
pends85527192pends
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558462pin_s
pints75936222pints
poinds93511142poinds
ponds85323402ponds
rands65930452rands
rends65129952rends
rids56539562ri_ds
rind56535612rind_
rindy95717402rindy
rings65029172rings
rinks94827102rinks
rins46153202rin_s
rynds9569972rynds
sands65228582sands
sends65528242sends
silds65520532silds
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755282sin_s
sinus55523852sinus
skids104615342ski_ds
skinks94511652skinks
skins94723472skin_s
teinds738262teinds
tends65425582tends
tines54848422tines
tings65329212tings
tins45251312tin_s
tints56030922tints
vends95520892vends
viands1047812viands
vids85627552vi_ds
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wands96425482wands
wends95822812wends
wilds94818212wilds
wind85533862wind_
windy126118112windy
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949182win_s
wynds126310372wynds
yids85224972yi_ds
yins75335132yin_s
yirds96612522yirds
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735012zin_s

Search took 3 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 Limit538002021.64032804.9
3Display Results2022020.0464391.3
 (SQL Overall)1786912021.99989390.2
 
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.