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

284 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
shits8473117(None) 
chits105424571chits
hits75545131_hits
shies86136551shies
shifts124412941shifts
shims104422551shims
shins85131041shins
ships105123771ships
shirts94918341shirts
shist84829611shist
shists96515111shists
shit76745941shit_
shivs115018801shivs
shots84730851shots
shuts85622481shuts
sits45050201s_its
skits94721861skits
slits56128851slits
snits54124831snits
spits74429551spits
suits55028051suits
whits115923821whits
adits66523712adits
ahis76135382ahi_s
aits46355532_aits
baits76630582baits
bhuts105812952bhuts
bits66148162_bits
brits76433082brits
chats105730092chats
chias104625522chias
chics123920942chics
chins105631462chins
chints115117832chints
chips125721252chips
chis95933312chi_s
chit96937462chit_
crits75527572crits
dits56450522_dits
doits66223672doits
duits65021882duits
edits65819032edits
emits75421472emits
exits125515912exits
fits76043462_fits
flits85625222flits
frits86129102frits
gaits65726012gaits
ghats95818612ghats
ghis85020162ghi_s
gits55744592_gits
grits65529582grits
hats76858252_hats
hets75547202_hets
hies74842832_hies
hilts86924412_hilts
hims95230972_hims
hins76447992_hins
hints87330622_hints
hips96433702_hips
his66359502_hi_s
hiss75629212_hiss
hist76551542_hist
hists86328372_hists
hit66569192_hit_
hots78349332_hots
huts76737442_huts
its35538832__its
khats125316012khats
khets124913432khets
khis117017982khi_s
kits86441762_kits
knits93914742knits
lits46252492_lits
mishits122513082mishits
nits45741642_nits
obits74617552obits
ohias84415572ohias
omits75018262omits
phis95724902phi_s
phots105418502phots
phuts104613502phuts
pits66348742_pits
quits144122352quits
sahibs1137082sahibs
saids65328852saids
sails55738102sails
sains55639972sains
saints65122422saints
saith85826552saith
salts55431882salts
satis55633682satis
scats75930602scats
schist11312652schist
schists1248542schists
schuits1235822schuits
scots74025912scots
scuts74522522scuts
seats54844342seats
sects75622892sects
seifs85019332seifs
seis45542392sei_s
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shads95124482shads
shafts125411442shafts
shags95123862shags
shahs115919512shahs
shams105829412shams
shat76456602shat_
shaws116226262shaws
shays116021432shays
sheas86331792sheas
sheds96122702sheds
sheets93918502sheets
sheiks132510012sheiks
shes75734352sh_es
shews115924712shews
shiatsu1033432shiatsu
shied96125492shied
shiel811023772shiel
shiels95418922shiels
shier85428942shier
shiers94921752shiers
shiest95821522shiest
shift114225142shift
shifty15409262shifty
shiksa1394652shiksa
shikse1386072shikse
shill85325332shill
shills94519612shills
shily115222012shily
shim95827862shi_m
shin75634312shi_n
shine85533092shine
shines95028912shines
shiny115122142shiny
ship95228242shi_p
shire84727132shire
shires95225572shires
shirk124817842shirk
shirks134814122shirks
shirr84716922shirr
shirrs94413172shirrs
shirt84533902shirt
shirty124312562shirty
shitty124110062shitty
shiv105721172shi_v
shiva115915002shiva
shivas124512412shivas
shive114423422shive
shives124921412shives
shoats94117082shoats
shoes85429662shoes
shogs95319712shogs
shoos84226362shoos
shoots94619362shoots
shops104222902shops
shorts95321742shorts
shot76150262shot_
shote85526102shote
shotes95321912shotes
shott85332192shott
shotts93614702shotts
shouts94017722shouts
shows115324582shows
shrifts1335962shrifts
shris84221452shris
shtik123210962shtik
shtiks13297832shtiks
shuls85319712shuls
shuns85018142shuns
shunts95712022shunts
shut76137592shut_
shute84520352shute
shutes93518222shutes
shwas116415102shwas
sibs65933542s_ibs
sics65234092s_ics
sifts84918922sifts
silts55330822silts
sims65737172s_ims
sins46755272s_ins
sips65740102s_ips
sirs44338332s_irs
sis37360542s_i_s
sit35877752s_it_
site47052412s_ite
sites56045432s_ites
sith75435152s_ith
situs55019232s_itus
skats94621542skats
skids104615322skids
skies95026832skies
skims114517192skims
skins94723462skins
skips115616602skips
skirts104111502skirts
skis84825292ski_s
skit85437532skit_
skite95120052skite
skites104418042skites
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
thins85826332thins
this76027382thi_s
tits46145042_tits
toits55327472toits
twits86015792twits
units54923432units
waits88333522waits
whats117718992whats
whets115019612whets
whids125413982whids
whigs125612642whigs
whims134515332whims
whins114922332whins
whips134917082whips
whirs115218092whirs
whist115322952whist
whists124613812whists
whit104834172whit_
white114920302white
whites123919882whites
whity145513472whity
wits76044872_wits
writs86624382writs
zits136030292_zits

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.310576422.6
2DLD Change Limit538002841.59333772.8
3Display Results2842840.0803550.0
 (SQL Overall)1786912841.98390111.4
 
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.