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

183 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
succah133664(None) 
succahs1435321succahs
buccal1248242buccal
siccan1037592siccan
subah106015212su_bah
succor1036622succor
succoth1445092succoth
such96424812su_c_h
sukkah12123732sukkah
sulcal8311272sulcal
sumach135310112sumach
sunnah9369352sunnah
surah86823252su_rah
yucca12467442yucca_
yuccas13426552yuccas
yucch15417432yucc_h
bacca111012183bacca_
baccae12119703baccae
bunch125118603bunc_h
butch125416543butc_h
coccal9310223coccal
culch124512833culc_h
curch124415413curc_h
cutch125116193cutc_h
ducal84816423du_cal
ducat86225903du_cat
ductal938993ductal
dunch115316263dunc_h
dutch114713823dutc_h
gulch113810603gulc_h
hubcap1553993hubcap
hunch136416213hunc_h
huppah1644183huppah
hurrah12369183hurrah
hutch135414093hutc_h
huzzah2044423huzzah
jubbah2034353jubbah
jubhah2142803jubhah
lunch104917243lunc_h
lurch104814633lurc_h
mecca1139933mecca_
meccas1239493meccas
much115224033mu_c_h
mudcap1335133mudcap
mudcat11311203mudcat
mulch124012973mulc_h
mullah113710733mullah
munch124917103munc_h
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
mutch125016173mutc_h
nucha10229793nucha_
nuchae11218513nuchae
nuchal11218873nuchal
nullah9388143nullah
ouch95724633ou_c_h
pucka133412803pucka_
pujah17478543pu_jah
punch125118423punc_h
punkah15347093punkah
purdah12288753purdah
rupiah1146213rupiah
saccade12107033saccade
saccate111311763saccate
sacra74516993sacra_
sacral83414413sacral
sauch104918773sauc_h
scab85926713s__cab
scad75725763s__cad
scag76626893s__cag
scam85932353s__cam
scan65530453s__can
scar66434203s__car
scat65848373s__cat
schav1338313s_chav
scrag85916173s_crag
scram910621613s_cram
scrap97120403s_crap
scuba94211593scuba_
scubas103710223scubas
sculch13226213sculch
scuta75815753scuta_
scutch13247083scutch
secco9312423secc_o
seccos1039923seccos
secpar1037923secpar
selah8319613s_elah
shah105627783s__hah
shibah14387463shibah
shivah15488533shivah
sicced11489653sicced
sirrah9379753sirrah
skycap1742913skycap
smutch13205843smutc_h
soca66330053s_oca_
socas74026183s_ocas
soccage1236283soccage
soccer1038543soccer
social8813333social
socman1039813socman
soucar839323soucar
sowcar1135863sowcar
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
stich104117923stic_h
stucco1044253stucc_o
stuccos1153933stuccos
suba64926603su_ba_
subahs114512383su_bahs
subas74724073su_bas
subclan1147173subclan
subpar1048663subpar
subway1447073subway
succeed1235983succeed
success1146403success
succors1137413succors
succory1444643succory
succotash1651883succotash
succour1144693succour
succuba1343443succuba
succubae1443083succubae
succubas1443853succubas
succubi1342883succubi
succumb1543283succumb
succuss1134993succuss
suck106131733su_c_k
sucked134120493sucked
sucker124120663sucker
suckle124015963suckle
sucks114523073su_cks
sucky144415503su_cky
sucrase9310343sucrase
sucre75019103su_cre
sucres84218893sucres
sugar6312913su_gar
sugh86423443su__gh
sukkahs1382703sukkahs
sulcate9314423sulcate
sulci7615053sulc_i
sulcus8410493sulcus
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sulpha1135403sulpha
sultan63012593sultan
sumac99514883su_mac
sumachs14457353sumachs
sumacs105512103sumacs
summa94713313summa_
summae103911013summae
summas104313163summas
sunbath1236423sunbath
sundae7312873sundae
sunna55016063sunna_
sunnahs10326593sunnahs
sunnas63914563sunnas
sunray9310123sunray
suntan62613003suntan
supra73614253supra_
sura45740293su_ra_
surahs94515543su_rahs
sural55931263su_ral
suras55336323su_ras
surcoat9412923surcoat
surra55521343surra_
surras65919533surras
surtax1337843surtax
sutra54217933sutra_
sutras64818583sutras
sutta54015333sutta_
suttas63813793suttas
synch135011793sync_h
tussah9356233tussah
uncap9312283_uncap
wicca1247253wicca_
wiccan1335033wiccan
wiccas1336543wiccas
yecch15558093yecc_h
yuca95716723yu_ca_
yucas106013913yu_cas
yuch125818533yu_c_h

Search took 7 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 Limit1127161836.72016773.2
3Display Results1831830.1101663.6
 (SQL Overall)1786911836.97025637.2
 
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.