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

112 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
blume9561989(None) 
blame95625491blame
blue65328461blu_e
blumed114313641blumed
blumes105917791blumes
brume95817981brume
flume106021171flume
glume85120461glume
plume94819461plume
alme65832162al_me
alum65227612alum_
alums75720602alums
berme96022942berme
biome94916992biome
blade85923332blade
blae66134642bl_ae
blam86131702blam_
blamed116017952blamed
blamer104417142blamer
blames105121862blames
blams95023852blams
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
blimey13468452blimey
blimp115612942blimp
blimy125212822blimy
blite76225352blite
bloke114316632bloke
blouse84714722blouse
blub85324872blu_b
blubs95818152blubs
bludge104210972bludge
blued84520322blued
bluer74918492bluer
blues75127042blues
bluet75631192bluet
bluey104817052bluey
bluff134413832bluff
blunge94311482blunge
blunt75525022blunt
blur66020532blu_r
blurb95214902blurb
blurs74619082blurs
blurt77625622blurt
blush105115312blush
blype12429672blype
boule74828042boule
bouse75931852bouse
brome94421972brome
brumes106417072brumes
brute75321782brute
bulge86419872bulge
bum75342692b_um_
bumf116126512b_umf
bump106228242b_ump
bums85934592b_ums
bute66739672b_ute
clime95720892clime
clue65324532clu_e
clump115517452clump
elude64517622elude
elute54822572elute
flame105124442flame
flue75329852flu_e
fluke125016892fluke
flumed124915262flumed
flumes115119732flumes
flump124614722flump
flute86823752flute
fume96727632_fume
glime85620192glime
glue55628492glu_e
glum75825102glum_
glumes94516812glumes
glums84621422glums
glute66020902glute
grume86218162grume
illume8298222illume
kluge104910462kluge
lame66849292_lame
lime66244942_lime
lube64731562_lube
luce65132572_luce
lude55331652_lude
luge55531642_luge
lum55542932_lum_
luma65527522_luma
lumen75220902_lumen
lump86531702_lump
lums65734242_lums
lune47140492_lune
lure45142462_lure
lute46341012_lute
luxe115222692_luxe
neume74414402neume
plum85122102plum_
plumb114514072plumb
plumed114412882plumed
plumes104318132plumes
plump115315262plump
plums94619952plums
plumy124213232plumy
relume8313272relume
slime74925752slime
slue45332192slu_e
slum65430512slum_
slump94816632slump
slums74623432slums
spume95817312spume
volume11358272volume

Search took 4 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 Filter178691538000.500357382.0
2DLD Change Limit538001122.73619663.7
3Display Results1121120.0303733.3
 (SQL Overall)1786911123.26654712.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.