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

72 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
schlumps174274(None) 
schlump1643261schlump_
schlumpy2041871schlumpy
shlumps1434141s_hlumps
chumps154313822_ch_umps
clumps1215314642_c_lumps
schlepps1762562schlepps
schleps1445482schl_eps
schlubs1443192schlu_bs
schlumped1941952schlumped
shlump1345712s_hlump_
shlumpy1742862s_hlumpy
slumps104313582s__lumps
champs154915683_ch_amps
chimps155713663_ch_imps
chlamys1733783_chlamys
chomps155112223_ch_omps
chump145315443_ch_ump_
chums125015833_ch_um_s
clamps124515083_c_lamps
clomps125212233_c_lomps
clump115517453_c_lump_
clumpy15409573_c_lumpy
columns1136473_columns
crumps124514343_c_rumps
flumps135112503__flumps
humps126322803__h_umps
lumps95624983___lumps
plumps124612613__plumps
scaleups1243393scaleups
scallops12297383scallops
scalps104315233scal__ps
scamps125014173sc__amps
scaups105411933sc_au_ps
schemas1468163sch_emas
schemes1489663sch_emes
schisms1437173schism_s
schlep1347093schl_ep_
schlepp1662953schl_epp
schlocks19245693schlocks
schlub1355003schlu__b
schlumpier1941473schlumpier
schlumpiest2051283schlumpiest
schlumping2041943schlumping
schmos13379153sch__mos
schmucks2142763schmucks
schnapps1752033schnapps
schnaps1443703sch_naps
scholiums1644833scholium_s
schuits1235823sch_uits
schuls11299853sch_u_ls
schuss11186733sch_u_ss
scollops12235693scollops
scrimps13517903sc_rimps
scrums104614253sc_rum_s
sculps104611753sc__ulps
scums95017423sc__um_s
scups95316653sc__u_ps
shlepps14394833s_hlepps
shleps114710333s_hl_eps
shlubs11386733s_hlu_bs
shlumped1643443s_hlumped
shrimps14516753s_hrimps
slump94816633s__lump_
slums74623433s__lum_s
slurps84410003s__lurps
solums85211333s_olum_s
stumps104912283s__tumps
sumps95023433s___umps
sunlamps1243293sunlamps
thumps13449353_th_umps
whumps16427093_wh_umps

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162728.12617987.0
3Display Results72720.0135538.5
 (SQL Overall)178691728.29521542.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.