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

90 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
bedroom124708(None) 
bedrooms1345711bedrooms
barroom1139382barroom
bedrock1645642bedrock
bedroll1055552bedroll
bedroomed1543652bedroomed
begloom1255242begloom
broom95022212b__room
headroom1446312headroom
legroom1076092legroom
mudroom1244952mudroom
redroot8312902redroot
regroom1077302regroom
tearoom939062tearoom
backroom1846093backroom
ballroom1245033ballroom
barrooms1237903barrooms
bathroom1545483bathroom
beadroll1144503beadroll
bearwood1445403bearwood
beblood12106083beblood
becrowd1555183becrowd
bedgown1443773bedgown
bedim10313833bed__im
bedlam1149273bed_lam
bedpost1247243bedpost
bedrail1037253bedrail
bedrape1277693bedrape
bedrid1039943bedr_id
bedrocks1745333bedrocks
bedrolls1144673bedrolls
bedrug10164953bedr_ug
bedrugs11194283bedrugs
bedsore1057803bedsore
beetroot1047253beetroot
befool1137713be_fool
beglooms1344273beglooms
begrim11118333begr_im
begroan1036103begroan
behoof1458683be_hoof
berm86732753be_r__m
besom95716973be__som
betook12439603be_took
betroth1247543betroth
beworm1339993be_worm
bloom95918973b__loom
boardroom1443153boardroom
boom87435673b___oom
breadroot1245553breadroot
bromo95217203b__romo
broo65129823b__roo_
brood84620243b__rood
brook114717763b__rook
brooms104915873b__rooms
broomy13449953b__roomy
broos75126413b__roos
budworm1545273budworm
dayroom1345233dayroom
doom76430073__d_oom
drool65416103__drool
droop85814823__droop
enroot6615993_enroot
gadroon938173gadroon
godroon946043godroon
groom85317983__groom
gunroom1045053gunroom
headrooms1555193headrooms
heirdom1344493heirdom
heirloom1342733heirloom
legrooms1185413legrooms
mudrooms1344083mudrooms
newsroom1343543newsroom
pedro8313153pedr_o_
pedros9312183pedr_os
rebloom1145663rebloom
redream10107913redream
redroots937753redroots
redrove11249423redrove
redwood1236523redwood
regrooms1196013regrooms
reproof1238783reproof
reroof9315003re_roof
restroom1047573restroom
room66235083___room
sunroom947013sunroom
taproom1147963taproom
tearooms1047843tearooms
varoom11411413_varoom
vroom105312473__vroom
wardroom1445043wardroom

Search took 9 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.486367677.0
2DLD Change Limit134027907.50017870.3
3Display Results90900.0303000.0
 (SQL Overall)178691908.01622291.8
 
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.