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

66 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
galumph1510266(None) 
galumphs1642021galumphs
galumphed1841412galumphed
gazump2032452gazump_
gazumps2131872gazumps
glumpy14527192g_lumpy
harumph1742932harumph
aleph10311393_al_eph
almah106917253_al_mah
almeh106214553_al_meh
alum65227613_alum__
alumin8513543_alumin
alumna857343_alumna
alumni856753_alumni
alums75720603_alum_s
bumph144911983__bumph
caliph13311403cal_iph
calumet11313293calumet
calumny1443863calumny
clump115517453_clump_
clumps1215314643_clumps
clumpy15409573_clumpy
flump124614723_flump_
flumps135112503_flumps
galah95917623gal__ah
gallop93311383gallop_
gallops103211653gallops
galop84716213gal_op_
galops94712613gal_ops
galosh1038553gal_osh
galumphing1941443galumphing
gamp98833213ga__mp_
gamps105323713ga__mps
gaum75726423ga_um__
gaumed104610323ga_umed
gaums86217073ga_um_s
gazumped2341403gazumped
gazumper2241463gazumper
glum75825103g_lum__
glume85120463g_lum_e
glumes94516813g_lumes
glumly12356623g_lumly
glums84621423g_lum_s
glunch1255353g_lunch
glyph1456473g_l_yph
grump105115313g_rump_
grumphy18443623g_rumphy
grumps114510573g_rumps
grumpy14498153g_rumpy
harrumph1841603harrumph
harumphs1841923harumphs
humph155712213__humph
kaliph1537873kal_iph
lump86531703__lump_
lumps95624983__lumps
lumpy126615913__lumpy
lymph1547043__lymph
plump115315263_plump_
plumps124612613_plumps
ralph1078743ral__ph
shlump1345713shlump_
shlumps1434143shlumps
shlumpy1742863shlumpy
slump94816633_slump_
slumps104313583_slumps
triumph1453333triumph

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027667.08018930.4
3Display Results66660.0302200.0
 (SQL Overall)178691667.26624592.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.