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

132 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
sitcoms114553(None) 
sitcom1036891sitcom_
simooms1135572simooms
syncoms1435942syncoms
aitches123014363aitches
atoms76817563_at_oms
bitches144117063bitches
bottoms1136993bottoms
ciscoes113610733ciscoes
ciscos104711133cisco_s
citrons92913223citrons
citrous93112993citrous
diatoms1039073diatoms
dicots94915793di_cots
dictums1235553dictums
discos94915213disco_s
ditches133215713ditches
dittos74111973ditto_s
fathoms1537523fathoms
ficoes114613463fi_coes
fitches153516193fitches
hitches153616273hitches
icons76516493_i_cons
idioms956413_idioms
incogs937903_incogs
income10712093_income
incomes11712373_incomes
itches114916213_itches
items7499613_it_ems
jetsoms16124723jetsoms
lictors93212593lictors
litchis1238373litchis
lithops12307253lithops
lithos94212553litho_s
nicols8810243ni_cols
nitons64614903nit_ons
nitros64214123nitro_s
nitrous73512483nitrous
noncoms1139193noncoms
outcome11310573outcome
outcomes1239763outcomes
picots104616443pi_cots
piscos105112593pisco_s
pitches143617753pitches
piteous9310683piteous
pitons85319043pit_ons
saintdoms1242493saintdoms
sarcoma1147403sarcoma
sarcomas1247223sarcomas
sarcous9312933sarcous
scams94423973s__cams
scops95820193s__cops
scots74025903s__cots
scows106617803s__cows
scums95017423s__cums
seccos1039923secco_s
sectors93116443sectors
setons64620173set_ons
setous64917373set_ous
shaloms1288983shaloms
shittims1344413shittims
sholoms1278023sholoms
sices75637273si_c_es
sickos125112033si_ckos
sicks115127623si_c_ks
sics65234093si_c__s
siglos7311473siglo_s
signors83410913signors
silicons10107153silicons
silos56029433si_lo_s
simious939803simious
simoom1037493simoom_
simoons937943simoons
sims65737173si___ms
sinuous739063sinuous
siphons1239353siphons
sistrums1055313sistrums
sitars65417593sit_ars
sites56045433sit__es
sithens1039383sithens
sits45050203sit___s
sitters74221553sitters
situps8538783sit_ups
situs55019233sit__us
situses72710493situses
sixmos1534813sixmo_s
slaloms9106543slaloms
snitches13148983snitches
sodoms989673s_odoms
soms66239373s___oms
sotols63714463sot_ols
steams84916903s_teams
stems75219953s_t_ems
stichs114511653stic_hs
sticks125118613stic_ks
stickums1643943stickums
stitches131410593stitches
stoas55126023s_t_oas
stobs75718233s_t_obs
stocks124715633s_tocks
stoma75918273s_t_oma
stomas84816323s_t_omas
stomp95616663s_t_omp
stomps105612833s_t_omps
stooks105115373s_tooks
stools65117023s_tools
stoops85917893s_toops
stops74827283s_t_ops
storms85814633s_torms
stoss54316343s_t_oss
stots54828543s_t_ots
stows86622703s_t_ows
stroma84313073s_troma
strops86220383s_trops
strows96718273s_trows
stroys95914603s_troys
strums84716453s_trums
stums75320083s_t_ums
succors1137413succors
suitors73012493suit_ors
switches16159133switches
syncom1336093syncom_
tictocs1145903tictocs
toms68343493__t_oms
victims1436003victims
victors123311183victors
viscous1238833viscous
wisdoms1335453wisdoms
witches152715793witches
wittols1035733wittols
zincous1837053zincous
zircons1854963zircons

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271328.17316398.8
3Display Results1321320.0304400.0
 (SQL Overall)1786911328.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.