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
kinds10622182(None) 
binds86627471binds
finds95424821finds
hinds96721471hinds
kids96029641ki_ds
kinas95626911kinas
kind96128561kind_
kines95039131kines
kings105825561kings
kinks84926081kinks
kinos96626141kinos
kins85747911kin_s
minds85427121minds
rinds64826141rinds
winds95425601winds
aids57846362ai_ds
ains46158882ain_s
ands57833612_ands
bands85233422bands
bends85628972bends
bids75838452bi_ds
bind76234512bind_
bindi85617012bindi
bindis94614582bindis
bines76946792bines
bins66548252bin_s
bints76130182bints
birds85421332birds
blinds95111612blinds
bonds86126842bonds
bunds85523542bunds
cines75239682cines
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
ends56528522_ends
fends96324972fends
fids87034742fi_ds
fiends104110292fiends
find87532602find_
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
fonds95824822fonds
funds94119252funds
gids65933742gi_ds
gilds75417522gilds
ginks104319562ginks
gins55543952gin_s
girds74816992girds
grinds84511842grinds
hands95327382hands
hind85529752hind_
hins76447992hin_s
hints87330622hints
ids47535472_i_ds
inks86926502_inks
inns46920932_inns
ins35945602_in_s
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
kains96125642kain_s
kanas95326912kanas
kanes95529372kanes
kendo105113222kendo
kendos114510662kendos
kenos95220622kenos
kens85435232ken_s
kiangs11378362kiangs
kibes115521112kibes
kicks104420082kicks
kid86540622ki_d_
kiddo11398952kiddo
kiddos12416862kiddos
kiddy144910282kiddy
kiefs126112202kiefs
kiers95320092kiers
kifs116023512ki_fs
kikes85122552kikes
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kin76353972kin__
kina85632002kin_a
kinase104210652kinase
kinder113716842kinder
kindest12311502kindest
kindle114414232kindle
kindles123614842kindles
kindly14358842kindly
kine85643432kin_e
king95933662kin_g
kinin94917322kinin
kinins104014582kinins
kink76034402kin_k
kinky115816382kinky
kino86233622kin_o
kips106430522ki_ps
kirks84915262kirks
kirns95315452kirns
kirs85831742ki_rs
kis78051482ki__s
kiss85227402ki_ss
kists95822112kists
kites95432542kites
kiths125814972kiths
kits86441772ki_ts
kivas124614732kivas
kiwis12328582kiwis
knits93914742knits
koines10415732koines
konks84917112konks
lands65426902lands
lends65326252lends
lids56336462li_ds
lindy96918312lindy
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
mends84927692mends
mids76541792mi_ds
milds86422052milds
minas75434112minas
mind75434382mind_
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
nines55937342nines
oinks94819912oinks
pends85527192pends
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558452pin_s
pints75936222pints
poinds93511142poinds
ponds85323402ponds
rands65930452rands
rends65129952rends
rids56539552ri_ds
rind56535602rind_
rindy95717392rindy
rings65029172rings
rinks94827102rinks
rins46153192rin_s
rynds9569972rynds
sands65228582sands
sends65528242sends
silds65520522silds
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
skids104615332ski_ds
skinks94511652skinks
skins94723462skin_s
teinds738262teinds
tends65425582tends
tines54848422tines
tings65329212tings
tins45251302tin_s
tints56030922tints
vends95520892vends
viands1047812viands
vids85627542vi_ds
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wands96425482wands
wends95822812wends
wilds94818202wilds
wind85533852wind_
windy126118102windy
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172win_s
wynds126310372wynds
yids85224962yi_ds
yins75335122yin_s
yirds96612512yirds
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735002zin_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 Limit538002022.04626295.2
3Display Results2022020.0633206.3
 (SQL Overall)1786912022.42273778.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.