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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
blumes10591779(None) 
blames105121861blames
blues75127041blu_es
blume95619891blume_
blumed114313641blumed
brumes106417071brumes
flumes115119731flumes
glumes94516811glumes
plumes104318131plumes
almes75126542al_mes
alums75720602alum_s
bermes106023002bermes
biomes103815252biomes
blades95221252blades
blame95625492blame_
blamed116017952blamed
blamer104417142blamer
blamers115314212blamers
blams95023852blam_s
blares85021632blares
blazes174817352blazes
blimey13468452blimey
blimps12588152blimps
blites84721212blites
blokes123813882blokes
blouses94014462blouses
blubs95818152blu_bs
bludges114511122bludges
blue65328462blu_e_
blued84520322blu_ed
bluer74918492blu_er
bluest84016482blu_est
bluesy11448982blu_esy
bluet75631192blu_et
bluets87215492bluets
bluey104817052blu_ey
blueys11419522blueys
bluffs14388372bluffs
blunges104212222blunges
blunts84512892blunts
blurbs10489312blurbs
blurs74619082blu_rs
blurts84412642blurts
blushes124314822blushes
blypes13357542blypes
boluses94113832boluses
boules84925972boules
bouses84931782bouses
bromes104719762bromes
brume95817982brume_
brutes86118682brutes
bruxes154811022bruxes
bulges95919322bulges
bumfs125414052b_umfs
bumps115921142b_umps
bums85934592b_um_s
buses75936012b_uses
butes714535872b_utes
climes104720002climes
clues74623032clu_es
clumps1215314642clumps
eludes75417682eludes
elutes64020312elutes
flames114723692flames
flues84626922flu_es
flukes135114192flukes
flume106021172flume_
flumed124915262flumed
flumps135112502flumps
flutes95421782flutes
fluxes165212932fluxes
fumes105224702_fumes
glimes94717522glimes
glues65125682glu_es
glume85120462glume_
glums84621422glum_s
glutes74517672glutes
grumes94415552grumes
illumes9327672illumes
kluges11389572kluges
lames75445542_lames
limes75636502_limes
lubes74727992_lubes
luces75528432_luces
ludes65728852_ludes
lues45943552_lu_es
luges65928752_luges
lumas75622912_lumas
lumen75220902_lumen
lumens85013972_lumens
lumps95624982_lumps
lums65734242_lum_s
lunes55337772_lunes
lures56138532_lures
lutes55836662_lutes
luxes124921502_luxes
neumes83112622neumes
plumbs12459332plumbs
plume94819462plume_
plumed114412882plumed
plumps124612612plumps
plums94619952plum_s
pluses83618072pluses
relumes9612512relumes
slimes84722042slimes
slues54527172slu_es
slumps104313582slumps
slums74623432slum_s
spumes1021314882spumes
volumes12298232volumes

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.346516448.0
2DLD Change Limit825511102.40334353.3
3Display Results1101100.0333333.3
 (SQL Overall)1786911102.78264231.1
 
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.