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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 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
chuppah195245(None) 
chuppa1543971chuppa_
chuppahs2042071chuppahs
chuppas1644121chuppas
huppah1644181_huppah
chuddah17263252chuddah
chutzpah2751412chutzpah
cuppa11398522c_uppa_
cuppas12458592c_uppas
huppahs1743332_huppahs
chalah143511653ch_alah
challah15458323challah
champac1834953champac
champak2034493champak
chapeau1435523chapeau
chapman1637893chapman
chappati17124003chappati
chapped172711443chapped
chappie16298653chappie
charpai1436623charpai
cheetah1545453cheetah
chetah14399583ch_etah
chipped174110813chipped
chipper163912583chipper
chippie16297693chippie
chippy18437613chipp_y
chopped174511003chopped
chopper163611893chopper
choppy18376293chopp_y
chuddahs18222583chuddahs
chuddar14263963chuddar
chufa13489113chu_fa_
chufas14397673chu_fas
chukar1534633chu_kar
chukka1433013chukka_
chukkar1542053chukkar
chukkas1532783chukkas
chump145315443chump__
chumped17379493chumped
chumps154313823chump_s
church1636483chu_rch
chutzpa2361763chutzpa_
chutzpahs2851093chutzpahs
chutzpas2451963chutzpas
coprah133710603c_oprah
crupper13338563crupper
culpa93610963c_ulpa_
culpae10389263c_ulpae
cupped134413983c_upped
cupper124313863c_upper
cuppy144710383c_upp_y
cuspal1037883c_uspal
humph155712213_hump_h
hurrah12369183_hurrah
hutzpah2441803_hutzpah
huzzah2044423_huzzah
rupiah1146213_rupiah
whupped18365413whupped

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.326548131.9
2DLD Change Limit134027588.31316122.6
3Display Results58580.0331757.6
 (SQL Overall)178691588.67220605.5
 
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.