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

86 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
broom9502221(None) 
bloom95918971bloom
boom87435671b_oom
bromo95217201bromo
broo65129821broo_
brood84620241brood
brook114717761brook
brooms104915871brooms
broomy13449951broomy
broos75126411broos
groom85317981groom
room66235081_room
vroom105312471vroom
abloom1039782abloom
barroom1139372barroom
bedroom1247082bedroom
besom95716972besom
bhoot104322102bhoot
blood85319522blood
blooms104613172blooms
bloomy134510112bloomy
bloop96116152bloop
boo58163662b_oo_
boob85932582b_oob
book106836332b_ook
booms95427122b_ooms
boomy125421822b_oomy
boon67142172b_oon
boor66130682b_oor
boos67955032b_oos
boot67759372b_oot
boron76727142boron
bosom95516922bosom
bream95121812bream
brim85629372br_im
brio65432492brio_
brios74725722brios
bro56236602br_o_
broad84817692broad
brock136017072brock
broil74918222broil
broke116019782broke
brome94421972brome
bromos104213312bromos
bronc91714342bronc
brooch13368442brooch
broods95416382broods
broody124510082broody
brooks125813882brooks
broomed124111052broomed
bros65635662br_os
brose75227032brose
brosy106115382brosy
broth106521092broth
brow97228442br_ow
brown105619532brown
brows105425982brows
buxom1647152buxom
crook115217572crook
croon75522782croon
doom76430072_doom
drool65416102drool
droop85814822droop
from96923922fr_om
gloom87116522gloom
grooms94512522grooms
kroon94514482kroon
loom67035052_loom
proem94818272proem
prom87631702pr_om
promo95620002promo
proof105221532proof
roam67132412_roam
rom59855632_r_om
rood56733002_rood
roof75738832_roof
rook85532032_rook
rooms75324682_rooms
roomy107118062_roomy
root45655922_root
toom66532932_toom
troop76417532troop
trooz145016152trooz
varoom11411412varoom
vrooms11398712vrooms
zoom156722102_zoom

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.673265514.1
2DLD Change Limit53800862.93618324.3
3Display Results86860.0461869.6
 (SQL Overall)178691863.65548889.5
 
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.