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

111 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
sukkah1212373(None) 
sukkahs1382701sukkahs
pukka10457132pukka_
punkah15347092punkah
subah106015212su_bah
succah1336642succah
sukkot936632sukkot
sukkoth1342082sukkoth
sunnah9369352sunnah
surah86823252su_rah
burka114617693burka_
burkas124513803burkas
chukka1433013chukka_
chukkar1542053chukkar
chukkas1532783chukkas
dumka12438833dumka_
hookah16488243hookah
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
jubbah2034353jubbah
jubhah2142803jubhah
mikvah18143473mikvah
mullah113710733mullah
nullah9388143nullah
pucka133412803pucka_
pujah17478543pu_jah
punka114515483punka_
punkahs16284783punkahs
punkas123410673punkas
purdah12288753purdah
quokka1841893quokka_
quokkas1942063quokkas
rupiah1146213rupiah
selah8319613s_elah
shah105627783s__hah
shibah14387463shibah
shikar1336803shikar
shivah15488533shivah
sika86021323s_ika_
sikas94617023s_ikas
sirrah9379753sirrah
ska76925863s__ka_
skag96321513s__kag
skas85325713s__kas
skat87037893s__kat
skean94415623s_kean
skoal93811453s_koal
skosh12407263s_kosh
skua86113153s_kua_
skuas95611733s_kuas
suba64926603su_ba_
subahs114512383su_bahs
subas74724073su_bas
subpar1048663subpar
subway1447073subway
succahs1435323succahs
such96424813su__ch
suck106131733suck__
sucked134120493sucked
sucker124120663sucker
suckle124015963suckle
sucks114523073suck_s
sucky144415503suck_y
sugar6312913su_gar
sugh86423443su__gh
suk75632973su_k__
suks85927123su_k_s
sulcal8311273sulcal
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sulk85326653sulk__
sulked114314703sulked
sulker104015923sulker
sulks94818463sulk_s
sulky124715363sulk_y
sulpha1135403sulpha
sultan63012593sultan
sumac99514883su_mac
sumach135310113sumach
summa94713313summa_
summae103911013summae
summas104313163summas
sunbath1236423sunbath
sundae7312873sundae
sunk85031813sunk__
sunken103511783sunken
sunket103721363sunket
sunna55016063sunna_
sunnahs10326593sunnahs
sunnas63914563sunnas
sunray9310123sunray
suntan62613003suntan
supra73614253supra_
sura45740293su_ra_
surahs94515543su_rahs
sural55931263su_ral
suras55336323su_ras
surra55521343surra_
surras65919533surras
surtax1337843surtax
sutra54217933sutra_
sutras64818583sutras
sutta54015333sutta_
suttas63813793suttas
tikka835573tikka_
tikkas934523tikkas
tussah9356233tussah
yukked13314873yukked
yukky14425213yukk_y

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 Limit1127161116.39317631.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.57927160.8
 
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.