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

137 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
huppah164418(None) 
chuppah1952451chuppah
huppahs1743331huppahs
chuppa1543972chuppa_
chuppahs2042072chuppahs
chuppas1644122chuppas
cuppa11398522cuppa_
cuppas12458592cuppas
humph155712212hump_h
hurrah12369182hurrah
hutzpah2441802hutzpah
huzzah2044422huzzah
rupiah1146212rupiah
appal95315223_appal
bumph144911983bump_h
buppie12288733buppie
buppy144810073bupp_y
chuddah17263253chuddah
chutzpah2751413chutzpah
coprah133710603coprah
culpa93610963culpa_
culpae10389263culpae
cupped134413983cupped
cupper124313863cupper
cuppy144710383cupp_y
cuspal1037883cuspal
dupped124411643dupped
ephah1337063_ephah
guppy135211273gupp_y
hah910655223h___ah
hallah124115403hallah
halvah15499833halvah
hamzah23135553hamzah
hapax1739323h_apax
happed144820103happed
happen134812193happen
happy155813533happ_y
hepcat13611823hepcat
hepper133412663hepper
heptad1237273heptad
hijrah1934273hijrah
hipparch2042823hipparch
hipped144317693hipped
hipper133818023hipper
hippie132811243hippie
hippish1736183hippish
hippo12369063hipp_o
hippos13408433hippos
hippy155112793hipp_y
hookah16488243hookah
hoorah124411113hoorah
hopped144318113hopped
hopper134218483hopper
hopple132910483hopple
hoppy154912353hopp_y
horah117922043h_orah
houdah1335173houdah
howdah1634723howdah
hubcap1553993hubcap
huh96432013hu___h
huipil1143773huipil
hula74923753hu_la_
hulas84920883hu_las
human102716033hu_man
hump116228723hump__
humped144015243humped
humper134115883humper
humphs16528163humphs
humps126322803hump_s
humpy155115673hump_y
hunch136416213hu_nch
hunh106323733hu__nh
hup86437813hu_p__
hurrahs13336773hurrahs
hurray12459913hurray
hush105224113hu__sh
hussar9317283hussar
hutch135414093hu_tch
hutzpa2052803hutzpa_
hutzpahs2541443hutzpahs
hutzpas2142693hutzpas
huzza1646093huzza_
huzzahs2143083huzzahs
huzzas1735863huzzas
hypha1637383hypha_
hyphae1746433hyphae
hyphal1736413hyphal
jubbah2034353jubbah
jubhah2142803jubhah
kappa13469743kappa_
kappas144410363kappas
koppa13397293koppa_
koppas14407603koppas
mullah113710733mullah
nappa98511863nappa_
nappas105511613nappas
nullah9388143nullah
oompah1334253oompah
opah96218403__opah
ouph95618373ou_p_h
pah88853593___pah
poppa8409893poppa_
poppas93710713poppas
pujah17478543pu_jah
pulpal10408453pulpal
punkah15347093punkah
pupa85422813pu_pa_
pupae96515643pu_pae
pupal97616873pu_pal
pupas95219283pu_pas
pupped105013273pupped
puppet93514593puppet
puppy114912413pupp_y
purdah12288753purdah
rupiahs1253333rupiahs
subah106015213su_bah
subpar1048663subpar
succah1336643succah
sukkah12123733sukkah
sulpha1135403sulpha
sunnah9369353sunnah
supped114415703supped
supper104115433supper
supple10410203supple
supply1346893supply
supra73614253supra_
surah86823253su_rah
tupped114013233tupped
tussah9356233tussah
ulpan7310123_ulpan
upas68322383_u_pas
upped103715163_upped
upper93714263_upper
uppish1336633_uppish
whupped18365413whupped
yuppie13297133yuppie
yuppy15487913yupp_y

Search took 8 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 Limit1127161377.42015190.8
3Display Results1371370.0961427.1
 (SQL Overall)1786911377.65623340.0
 
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.