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

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

126 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
enrobers1023695(None) 
enrober9218621enrober_
enrobes92211111enrobe_s
encoders1137512encoders
endowers1238232endowers
enjoyers1843882enjoyers
ennoblers1143192ennoblers
enrobe86610792enrobe__
enrobed10279252enrobe_d
enrollers976172enrollers
probers113514582_probers
unrobes9269732unrobe_s
aerobes9311493aerobe_s
annoyers1185033annoyers
barbers114317503bar_bers
bribers114111503_bribers
brokers133111913_brokers
carolers103314173carolers
coroners104016223coroners
crowers124614903_crowers
crozers184111083_crozers
curbers115514383cur_bers
disrobers1246383disrobers
droners84114383_droners
drovers115212643_drovers
earlobes1056143earlobe_s
earners74016453ear_ners
echoers12459693echo_ers
elopers95112943e_lopers
embers104116183e__mbers
embowers15236453embowers
emoters94712873e_moters
empowers15276843empowers
enablers10196913enablers
enclosers11105803enclosers
encoder1038633encoder_
encodes10310643encode_s
encores9315213encore_s
encumbers1543793encumbers
enders74324053en__ders
endoderm12115253endoderm
endoderms13124743endoderms
endogens1047953endogens
endorsers1046123endorsers
endower1138483endower_
endurers9317953endurers
enfevers1444513enfevers
enfolders1395093enfolders
enforcers14215213enforcers
engagers10246553engagers
engravers1344313engravers
engrossers1143093engrossers
enjoiners16234623enjoiners
enjoyer1744383enjoyer_
ennobler1043543ennobler_
ennobles1045113ennobles
enrages83114853enrage_s
enrichers1444133enrichers
enrobing1137433enrobing
enrollees974323enrollees
enroller867183enroller_
enrolls7108093enro_lls
enrols61213383enro__ls
enroots738713enro_ots
ensurers8279373ensurers
enterers82214153enterers
enters64425643en__ters
enticers10139093enticers
entoderm1175343entoderm
entoderms12114303entoderms
enviers1036993en_viers
erasers74413943e_rasers
erodes74819883e_rode_s
eroses65327053e_rose_s
errors63311313erro__rs
estovers1136453estovers
evokers14386793e_vokers
exposers1736133exposers
goobers10219623_goobers
grocers103511253_grocers
gropers104813853_gropers
growers113612723_growers
incomers1268593incomers
intoners889933intoners
invokers1534673invokers
ironers74813553_ironers
knowers1436353kn_owers
nabbers113710463_nabbers
noosers74913923_noosers
noters64021003_n_oters
numbers113711243_numbers
prober104516073_prober_
probes104119453_probe_s
propers113619033_propers
prosers94219643_prosers
provers123817793_provers
renumbers1344123renumbers
reprobes121910293reprobe_s
reprovers14217773reprovers
robbers112814163__robbers
robes75133303__robe_s
rogers74517913__rogers
ropers84325903__ropers
rovers95423523__rovers
rowers94924573__rowers
scribers12307963scribers
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snorers74313803sn_orers
snorters83410583snorters
snubbers12326673snubbers
sobers85218863__sobers
strobes93813263strobe_s
strokers123910903strokers
stroyers11388923stroyers
tenoners858713ten_oners
throbbers1643173throbbers
throwers14106033throwers
trovers103713323_trovers
uncovers1336573uncovers
undoers82910583undo_ers
unrobe82611673unrobe__
unrobed102711213unrobe_d
unsober967643unsober_
venomers1336703ven_omers

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621267.40619735.6
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.88822653.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.