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

135 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
knits9391474(None) 
kits86441771k_its
knit85728141knit_
knots95614721knots
nits45741641_nits
snits54124831snits
units54923431units
adits66523712adits
aits46355532_aits
anils56326722anils
anis45746462ani_s
antis55033312antis
ants47243472an_ts
baits76630582baits
binits85716672binits
bints76130182bints
bits66148162_bits
brits76433082brits
chits105424572chits
crits75527572crits
dints67431312dints
dits56450522_dits
doits66223672doits
duits65021882duits
edits65819032edits
emits75421472emits
exits125515912exits
fits76043462_fits
flits85625222flits
frits86129102frits
gaits65726012gaits
gits55744592_gits
gnats65217712gnats
grits65529582grits
hints87330622hints
hits75545132_hits
intis55121642intis
its35538832__its
kaifs125715642kaifs
kails95525212kails
kainits1137762kainits
kains96125642kains
karts97630112karts
kats85944332k_ats
keets95123482keets
keirs95313672keirs
kelts95222632kelts
khats125316012khats
khets124913432khets
khis117017982khi_s
kids96029642k_ids
kifs116023512k_ifs
kilts95122182kilts
kinas95626912kinas
kinds106221822kinds
kines95039132kines
kings105825562kings
kinins104014582kinins
kinks84926082kinks
kinos96626142kinos
kins85747912k_ins
kips106430522k_ips
kirs85831742k_irs
kis78051482k_i_s
kiss85227402k_iss
kist86540802k_ist
kists95822112kists
kit78559882k_it_
kite85338242k_ite
kites95432542k_ites
kith115826362k_ith
kiths125814972k_iths
kliks8398822kliks
knaps115511172knaps
knars94416112knars
knees95114872knees
knife1210010132knife
knifes136210212knifes
knights1545652knights
knish1238602knish
knives13458552knives
knobs11519712knobs
knops115911812knops
knot85630502knot_
knouts10438312knouts
knows124912412knows
knurs94511152knurs
kois85129402koi_s
kraits104912202kraits
kris86423602kri_s
kyats125012442kyats
lints57137192lints
lits46252492_lits
mints76834042mints
nets45941532_nets
nibs65028312_nibs
nils46132452_nils
nims66226882_nims
nips65830922_nips
nit37065942_nit_
nite45943582_nite
nites55736342_nites
nuts45032672_nuts
obits74617552obits
omits75018262omits
pints75936222pints
pits66348742_pits
quits144122352quits
reknits1137072reknits
shits84731172shits
sits45050202_sits
skits94721862skits
slits56128852slits
snibs75613762snibs
snips75818012snips
snit46342472snit_
snots55225122snots
spits74429552spits
suits55028052suits
tints56030922tints
tits46145042_tits
toits55327472toits
twits86015792twits
unfits93910292unfits
unit45140072unit_
unite54828382unite
unites65024852unites
unity84918492unity
unknits1135552unknits
unwits9389892unwits
waits88333522waits
whits115923822whits
wits76044872_wits
writs86624382writs
zits136030292_zits

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 Limit538001351.57634137.1
3Display Results1351350.0462934.8
 (SQL Overall)1786911351.93592346.8
 
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.