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

166 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
enrober921861(None) 
enrobe86610791enrobe_
enrobed10279251enrobed
enrobers10236941enrobers
enrobes92211111enrobes
encoder1038632encoder
endower1138482endower
enjoyer1744382enjoyer
ennobler1043542ennobler
enroller867182enroller
prober104516072_prober
unrobe82611672unrobe_
unrobed102711212unrobed
unrobes9269732unrobes
unsober967622unsober
aerobe8412403aerobe_
aerobes9311493aerobes
annoyer1095603annoyer
barber104419323bar_ber
berobed1238233berobed
briber104714043_briber
broker124314243_broker
caroler93816753caroler
coroner94218203coroner
crower114117553_crower
crozer175112843_crozer
curber104517053cur_ber
disrober1147603disrober
droner74717673_droner
drover104614593_drover
earlier72612743earlier
earlobe946543earlobe_
earlobes1056143earlobes
earner63617223ear_ner
echoer114011103echo_er
eerier64320023eer_ier
eloper85414153e_loper
ember95516793e__mber
embower14267403embower
emoter85415193e_moter
empower14217033empower
enabler9299363enabler
encloser10107183encloser
encode9310443encode_
encoded1139033encoded
encoders1137513encoders
encodes10310643encodes
encore8314773encore_
encored10412103encored
encores9315213encores
encumber1454143encumber
ender64325863en__der
endoderm12115253endoderm
endogen938613endogen
endorser966733endorser
endowed1248173endowed
endowers1238233endowers
endurer83210363endurer
enfever1344643enfever
enfolder1286153enfolder
enforcer13246503enforcer
engager9278603engager
engraver1245333engraver
engrosser1043843engrosser
enjoiner15225653enjoiner
enjoyed1834523enjoyed
enjoyers1843883enjoyers
ennoble935633ennoble
ennobled1143823ennobled
ennoblers1143193ennoblers
ennobles1045113ennobles
enrage72715073enrage_
enraged93511783enraged
enrages83114853enrages
enricher1345003enricher
enrobing1137433enrobing
enrol51014283enro__l
enroll61110073enro_ll
enrolled967963enrolled
enrollee878343enrollee
enrollers976173enrollers
enrolls7108093enrolls
enrols61213383enro_ls
enroot6615993enro_ot
enrooted977423enrooted
enroots738713enroots
ensurer73011903ensurer
enter54726383en__ter
enterer72015633enterer
enticer91510423enticer
entoderm1175343entoderm
entombed13104503entombed
envier939673en_vier
enwombed16122943enwombed
eraser64216333e_raser
erode64520993e_rode_
eroded84313583e_roded
erodes74819883e_rodes
erose55727273e_rose_
eroses65327053e_roses
error53712233erro__r
evoker13467913e_voker
exposer1637413exposer
goober93911733_goober
grocer94212143_grocer
groper94517253_groper
grower104614933_grower
incomer1169933incomer
intoner7811663intoner
invoker1435353invoker
ironer64216443_ironer
knower1337073kn_ower
kroner104612573_kroner
nabber104913543_nabber
nerdier83110353nerdier
nervier10298833nervier
nobler83713453_n_obler
nooser65517823_nooser
noter55025643_n_oter
number103913223_number
probe94320813_probe_
probed114114823_probed
probers113514573_probers
probes104119453_probes
proper104319953_proper
proser84223463_proser
prover113819723_prover
prower114218123_prower
renumber1244243renumber
reprobe112310133reprobe_
reprobed13228743reprobed
reprobes121910293reprobes
reprover13229203reprover
robber103916533__robber
robe65335643__robe_
robed85323733__robed
robes75133303__robes
roger64521413__roger
roper75431913__roper
rover85527373__rover
rower85430493__rower
scriber113910963scriber
snooker113910303snooker
snooper93511533snooper
snoozer16409183snoozer
snorer64316763sn_orer
snorter74412653snorter
snubber11277733snubber
sober74822403__sober
strobe84513813strobe_
strobes93813263strobes
stroker114113513stroker
stroyer103510773stroyer
tenoner739673ten_oner
throbber1543203throbber
thrower1386993thrower
trover95014663_trover
uncover1239003uncover
undoer73113043undo_er
unlobed10219743unlobed
unprobed1366973unprobed
unriper9188283unriper
unroped102812103unroped
unrove92511683unrove_
unroven10238143unroven
venomer1237583ven_omer

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 Filter1786911340270.203880251.2
2DLD Change Limit1340271667.22018563.3
3Display Results1661660.0931784.9
 (SQL Overall)1786911667.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.