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

109 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
shlumping173337(None) 
schlumping2041941schlumping
slumping13359971s_lumping
chumping18349062ch_umping
clumping15319882_clumping
flumping16287582_flumping
humping153213072_h_umping
lumping123314642__lumping
plumping15277632_plumping
shlepping1733392shlepping
shrimping1734062shrimping
slumming13278382s_lumming
slurping11278122s_lurping
stumping13289082s_tumping
thumping16296712th_umping
whumping19325402wh_umping
bluming123511283_blum_ing
bumping143812493__bumping
champing183610933ch_amping
chomping18339883ch_omping
chumming18366203ch_umming
clamping154011153_clamping
clomping15329653_clomping
crumping15319903_crumping
dumping133712913__dumping
fluming133512793_flum_ing
galumphing1941443galumphing
gazumping2441443gazumping
grumping14266903_grumping
humming153310673_h_umming
humphing1935163_h_umphing
illuming1135873illum_ing
jumping19319803__jumping
lamping123116003__lamping
limping124614103__limping
mumping143411633__mumping
plumbing15286433_plumbing
pluming123412043_plum_ing
pumping144213553__pumping
reluming11310013relum_ing
repumping1634813repumping
saluting9310553salu_ting
scamping153510193s_camping
schlepping2041743schlepping
schlumpier1941473schlumpier
scrimping1634953scrimping
scrumming1654023scrumming
sculping13298943s_culping
scumming15256793s_cumming
shaming133016743sh_am_ing
shamming16289413sh_amming
shammying2042953shammying
shaping133116183sh__aping
sharping143011373sh_arping
shauling1249393shau_ling
shimming16278253sh_imming
shimmying2042533shimmying
shipping163611253sh_ipping
shlump1345713shlump___
shlumped1643443shlump_ed
shlumps1434143shlump__s
shlumpy1742863shlump__y
shopping163611283sh_opping
shouting122711783shou_ting
shrugging1533703shrugging
shucking18339433sh_ucking
shunning12367843sh_unning
shunting123610423sh_unting
shushing15317743sh_ushing
shuting113212043sh_u_ting
shutting12309683sh_utting
siruping1136503siru_ping
skimping17306243s_kimping
slamming133310003s_lamming
slapping133510833s_lapping
sleeping113812053s_leeping
sliming102913953s_lim_ing
slimming13288093s_limming
sliping103314413s_l_iping
slipping133510663s_lipping
sloping104114073s_l_oping
slopping133811423s_lopping
slubbing13248033s_lubbing
sludging11268363s_ludging
sluffing15247303s_luffing
slugging11339423s_lugging
sluicing1137063s_luicing
sluing74315883s_lu__ing
slurring9288833s_lurring
slushing12299643s_lushing
souping104215533s_ou_ping
splurging1333623splurging
spuming1248523s_pum_ing
stamping133310963s_tamping
stomping13309763s_tomping
strumming1454413strumming
stumming13347673s_tumming
summing122912383s__umming
supping123814533s__upping
swamping16307923s_wamping
syruping1434253syru_ping
thrumming1742903thrumming
thumbing16245513th_umbing
trumping13308733_trumping
tumping123114243__tumping
umping114815323___umping
voluming1435043volum_ing
whomping19285943wh_omping
whupping19345243wh_upping

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411097.70319296.5
3Display Results1091090.0303633.3
 (SQL Overall)1786911097.88922650.7
 
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.