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

219 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
skits9472186(None) 
kits86441771_kits
shits84731171shits
sits45050201s_its
skats94621541skats
skids104615331skids
skies95026831skies
skims114517191skims
skins94723461skins
skips115616601skips
skirts104111501skirts
skis84825291ski_s
skit85437531skit_
skite95120051skite
skites104418041skites
slits56128851slits
snits54124831snits
spits74429551spits
suits55028051suits
adits66523712adits
aits46355532_aits
baits76630582baits
bits66148162_bits
brits76433082brits
chits105424572chits
crits75527572crits
dits56450522_dits
doits66223672doits
duits65021882duits
edits65819032edits
emits75421472emits
exits125515912exits
fits76043462_fits
flits85625222flits
frits86129102frits
gaits65726012gaits
gits55744592_gits
grits65529582grits
hits75545132_hits
ikats95311152ikats
its35538832__its
kats85944332_kats
kids96029642_kids
kifs116023512_kifs
kilts95122182_kilts
kins85747912_kins
kips106430522_kips
kirs85831742_kirs
kis78051482_ki_s
kiss85227402_kiss
kist86540802_kist
kists95822112_kists
kit78559882_kit_
kite85338242_kite
kites95432542_kites
kith115826362_kith
kiths125814972_kiths
knits93914742knits
lits46252492_lits
muskits13278562muskits
nits45741642_nits
obits74617552obits
omits75018262omits
pits66348742_pits
quits144122352quits
saids65328852saids
sails55738102sails
sains55639972sains
saints65122422saints
saith85826552saith
sakis95323672saki_s
salts55431882salts
satis55633682satis
scats75930602scats
scots74025912scots
scuts74522522scuts
seats54844342seats
sects75622892sects
seifs85019332seifs
seis45542392sei_s
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shies86136552shies
shifts124412942shifts
shims104422552shims
shins85131042shins
ships105123772ships
shirts94918342shirts
shist84829612shist
shists96515112shists
shit76745942shit_
shivs115018802shivs
shots84730852shots
shuts85622482shuts
sibs65933542s_ibs
sics65234092s_ics
sifts84918922sifts
sikas94617022sikas
sikes96236082sikes
silts55330822silts
sims65737172s_ims
sins46755272s_ins
sips65740102s_ips
sirs44338332s_irs
sis37360542s_i_s
sit35877752s_it_
site47052412s_ite
sites56045432s_ites
sith75435152s_ith
situs55019232s_itus
skags104316072skags
skas85325712sk_as
skat87037902skat_
skate94721552skate
skates104219402skates
skees95023122skees
skeets104513252skeets
skegs105011232skegs
skeins103911902skeins
skeps115614252skeps
skews125413802skews
ski74925692ski__
skid95720932ski_d
skied104417752skied
skier95119592skier
skiers104713702skiers
skiey125012892skiey
skiff153612802skiff
skiffs16327012skiffs
skill94316722skill
skills104313922skills
skim105322512ski_m
skimo116312542skimo
skimos12548802skimos
skimp135411322skimp
skimps14488042skimps
skin85927532ski_n
skink85916852skink
skinks94511652skinks
skint95629222skint
skip105421752ski_p
skirl96012912skirl
skirls10449822skirls
skirr94810542skirr
skirrs10448192skirrs
skirt95624662skirt
skited114313482skited
skive124614112skive
skives134113942skives
skorts104211302skorts
skuas95611732skuas
slats55436902slats
slims75423652slims
slips76023722slips
slit46250102slit_
slots54830532slots
sluts54523982sluts
smit65138412smit_
smite75224872smite
smites83921922smites
smith107818052smith
smiths114711022smiths
smuts75415712smuts
snibs75613762snibs
snips75818012snips
snit46342472snit_
snots55225122snots
softs85019232softs
soils55327982soils
soots55536212soots
sorts54536662sorts
sots45552452s_ots
spaits85017472spaits
spats75031382spats
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spirts85317132spirts
spit65545082spit_
spite75430662spite
spites84127332spites
spitz166017972spitz
spivs105114242spivs
splits85416412splits
spots74424112spots
sprits85122532sprits
sris45434152sri_s
stats55933362stats
stets55423912stets
sties55132982sties
stilts67915312stilts
stints65119762stints
stirs55921622stirs
stots54828552stots
suets55126102suets
suints64617782suints
suit45649872suit_
suite54829562suite
suites63727402suites
swats85726862swats
swifts12408172swifts
swigs96213662swigs
swims105514142swims
swiss86712902swiss
swith115917402swith
swots85518432swots
tits46145042_tits
toits55327472toits
twits86015792twits
units54923432units
waits88333522waits
weskits1434742weskits
whits115923822whits
wits76044872_wits
writs86624382writs
zits136030292_zits

Search took 5 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.343520965.0
2DLD Change Limit538002193.31316239.1
3Display Results2192190.623351.5
 (SQL Overall)1786912194.27941760.0
 
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.