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

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

44 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
dumbly1439960(None) 
humbly164010521humbly
mumbly15319461mumbly
numbly134410661numbly
rumbly134412161rumbly
bubbly124110352bubbly
bumble124216892bumble
burbly134311152burbly
crumbly16347522crumbly
damply14337892damply
dimly114913482dim_ly
dimply14339742dimply
doubly12328962doubly
drably123511612drably
drumble12337892drumble
drumly1235702drum_ly
dually103210062dually
dully94921632du_lly
duly85323032du__ly
dumb97124102dumb__
dumbed124012082dumbed
dumber114414172dumber
dumbo105614062dumb_o
dumbos114111082dumbos
dumbs105915752dumb_s
dumky154511342dum_ky
dummy134712782dum_my
dumpily1566232dumpily
dumpy135414752dum_py
durably13229052durably
fumble133214262fumble
grumbly15355402grumbly
hubbly16478412hubbly
humble133615052humble
jumble174012652jumble
mumble123614342mumble
nimbly13388772nimbly
nubbly13369672nubbly
rubbly133710612rubbly
rumble103718812rumble
rumply13348572rumply
suably112814532suably
tumble103215642tumble
wambly16388662wambly

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551442.51632810.4
3Display Results44440.0133384.6
 (SQL Overall)178691442.88961852.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.