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 “sitcom” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

153 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
sitcom103690(None) 
sitcoms1145531sitcoms
simoom1037502simoom
syncom1336092syncom
aitch105216163aitc_h
atom67824523_at_om
bitch125017763bitc_h
bitchy16479203bitchy
bottom1048723bottom
cisco95112133cisco_
ciscos104711133ciscos
citron83112983citron
diatom939453diatom
dicot85429093di_cot
dictum1136863dictum
disco85616073disco_
discos94915213discos
ditch115015093ditc_h
ditto65315603ditto_
dittos74111973dittos
fathom1437473fathom
fico95824593fi_co_
fitch134816873fitc_h
fitchy17437623fitchy
hitch134515473hitc_h
icon66922043_i_con
idiom899963_idiom
incog838253_incog
income10712093_income
itch95619173_itc_h
itchy13449013_itchy
item65620383_it_em
jetsom15126143jetsom
lictor83610853lictor
lissom837403lissom
litchi1137893litchi
litho86513783litho_
lithos94212553lithos
nicol71113293ni_col
niton55418283nit_on
nitro54914353nitro_
nitros64214123nitros
noncom1039683noncom
outcome11310573outcome
picot95031013pi_cot
pisco96314983pisco_
piscos105112593piscos
pitch125018413pitc_h
pitchy16479673pitchy
piton76121583pit_on
saintdom1142463saintdom
sarcoma1147403sarcoma
satem76021463sat_em
scam85932353s__cam
scop85925523s__cop
scot66242613s__cot
scow96021423s__cow
scum85924523s__cum
secco9312423secco_
seccos1039923seccos
sector83415923sector
seldom939403seldom
seton55223543set_on
shalom11810923shalom
shittim1245133shittim
sholom11910113sholom
sic55847873si_c__
siccan1037593siccan
sicced11489653sicced
sice65545593si_c_e
sices75637273si_ces
sick106435573si_c_k
sicko115315393si_cko
sickos125112033sickos
sicks115127623si_cks
sics65234093si_c_s
sigloi737743sigloi
siglos7311473siglos
siglum936563siglum
signor73510353signor
silicon9117533silicon
silo46037913si_lo_
silos56029433si_los
sim56553143si___m
simooms1135573simooms
simoon858063simoon
since75024173sinc_e
siphon1138463siphon
sistrum946563sistrum
sit35877753sit___
sitar54820543sit_ar
sitars65417593sitars
site47052413sit__e
sited65130743sit_ed
sites56045433sit_es
sith75435153sit__h
siting74126623siting
sits45050203sit__s
sitten64113823sitten
sitter63323383sitter
situp74414063sit_up
situps8538783situps
situs55019233sit_us
sixmo1448303sixmo_
sixmos1534813sixmos
slalom888173slalom
snitch11357943snitc_h
sodom8814913s_odom
som59153813s___om
sotol54917653sot_ol
steam76322933s_team
stem610628253s_t_em
stich104117923stic_h
stichs114511653stichs
stick115121563stic_k
sticks125118613sticks
stickum1534823stickum
sticky154711343sticky
stitch11419103stitc_h
stoa45425913s_t_oa
stob66724613s_t_ob
stock114417563s_tock
stoma75918273s_t_oma
stomp95616663s_t_omp
stood65517713s_tood
stook95218213s_took
stool55619893s_tool
stoop75821543s_toop
stop66532033s_t_op
storm76520393s_torm
stot46347333s_t_ot
stow77325743s_t_ow
stroma84313073s_troma
strop77422243s_trop
strow88920573s_trow
stroy87720393s_troy
strum75619453s_trum
stum65526023s_t_um
succor1036623succor
suitor63311053suit_or
switch14458913switc_h
syncoms1435943syncoms
tictoc1036003tictoc
tom514358053__t_om
toom66532933__toom
victim1337693victim
victor113210673victor
wilco1039443wilco_
wisdom1235983wisdom
witch134517563witc_h
witchy17468593witchy
wittol935923wittol
zircon1754953zircon

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161535.62620034.8
3Display Results1531530.0463326.1
 (SQL Overall)1786911535.81230745.2
 
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.