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

92 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
rebloom114565(None) 
reblooms1244281reblooms
abloom1039782_abloom
beblood12106082beblood
begloom1255242begloom
bloom95918972__bloom
preboom1348242preb_oom
rebeldom1342472rebeldom
rebloomed1453282rebloomed
rebook125213202reb_ook
reboot84119332reb_oot
reflood1136362reflood
regroom1077292regroom
relook104813742re_look
bebloods13115233bebloods
bedroom1247083bedroom
beglooms1344273beglooms
blood85319523__blood
blooms104613173__blooms
bloomy134510113__bloomy
bloop96116153__bloop
boom87435673__b_oom
broom95022213__broom
celom9515683ce_l_om
ebook114510803_eb_ook
foreboom1546123foreb_oom
gloom87116523__gloom
heirloom1342733heirloom
jibboom2092493jibboom
legroom1076093legroom
loom67035053___loom
outbloom1244003outbloom
oxblood1743603oxblood
prebook1557523preb_ook
pureblood1471943pureblood
realism93115923realism
reallot7312133reallot
realm75621623real__m
realtor73611353realtor
rebato83714683rebato_
rebatos92913113rebatos
rebeldoms1442283rebeldoms
reblend1036653reblend
reblent9614253reblent
reblooming1543423reblooming
rebody1238153reb_ody
reboil83814683reb_oil
rebooks134010513rebooks
reboots93512093reboots
rebop9313283reb__op
rebops10311433reb_ops
rebore86625643reb_ore
reborn810016953reb_orn
rebozo1737323reb_ozo
rebozos1835143rebozos
reclaim1137753reclaim
recolor978693recolor
recook125513923re_cook
redroot8312903redroot
redwood1236513redwood
refloat10310833refloat
refloods1245553refloods
reflow12379653refl_ow
reflown13316213reflown
reflows13258983reflows
reform11312703re_form
regloss8218023regloss
reglow10339403regl_ow
reglows11288843reglows
regrooms1196013regrooms
reload7413893re_load
reloan6415693re_loan
relock124713523re_lock
relooks114010723re_looks
replot83818593repl_ot
replots93412633replots
replow114210343repl_ow
replows12329703replows
reproof1238783reproof
reroof9315003re_roof
reshoot102513893reshoot
respool937643respool
restroom1047573restroom
retook104313443re_took
retool63914483re_tool
room66235083r___oom
seldom939403se_ldom
tearoom939063tearoom
webfoot1544213webfoot
weblog1234223webl_og
weblogs1334223weblogs
webworm1744303webworm

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027926.06322105.7
3Display Results92920.0303066.7
 (SQL Overall)178691926.24928595.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.