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

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

107 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
erode6452099(None) 
epode85114091epode
eroded84313581eroded
erodes74819881erodes
erose55727271erose
rode55844301_rode
trode65322851trode
abode85518812abode
aerobe8412402aerobe
anode65021032anode
arose55832082arose
bode75838752_bode
brede85520502brede
bride86425532bride
broke116019782broke
brome94421972brome
brose75227032brose
code77347732_code
crone75231332crone
crore74922862crore
croze164719452croze
crude86018572crude
decode104414742decode
demode104013462demode
deride84420032deride
diode74716112diode
drone65324982drone
drove95518062drove
eide55832232e_ide
elide64922642elide
elodea738672elodea
elope75219342elope
elude64517622elude
emote75421192emote
emyde1136382emyde
encode9310442encode
enrobe86610792enrobe
epodes94315562epodes
erase54925492erase
ere36352772er__e
erne46727422er_ne
erodent8313822erodent
eros45238452ero_s
eroses65327052eroses
erred65915672erred
etude63612302etude
evade938182evade
evoke12478852evoke
exude134010292exude
froe75329992fro_e
frore86218802frore
froze174515652froze
geode7412592geode
grade75126092grade
gride75223582gride
grody103412062grody
grope84821612grope
grove95219332grove
horde94623052horde
irade65618152irade
irone55126362irone
krone94018732krone
lode56240112_lode
merde84320122mer_de
mode75840302_mode
node513036882_node
ode47446582__ode
oroide7311702oroide
pride84724732pride
probe94320812probe
prod76129502prod_
prods85523552prods
prole74527792prole
prone75332622prone
prose75835122prose
prove104823192prove
prude84615972prude
recode93618712recode
rede55037662_rede
rerose63320842rerose
ride55945122_ride
robe65335642_robe
rod47953892_rod_
rodeo65921092_rodeo
rodes614039082_rodes
rods56442062_rods
roe36861072_ro_e
role45851822_role
rope65542912_rope
rose46148902_rose
rote46249022_rote
roue45941742_roue
rove75136982_rove
rude55632782_rude
sarode75317512sarode
spode84617702spode
strode75215972strode
tetrode839332tetrode
trade65026042trade
triode75311892triode
trod57627952trod_
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
wrote84717482wrote
zeroed16409412zeroed

Search took 5 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.186960704.3
2DLD Change Limit538001073.84313999.5
3Display Results1071070.0631698.4
 (SQL Overall)1786911074.09243668.4
 
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.