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

111 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
hagrode123644(None) 
hagride1237551hagride
hagrider1334482hagrider
hagrides1337622hagrides
hayride1437322hayride
sarode75317512sa_rode
abode85518813_a_bode
abrade9313053_abrade
acnode938193_acnode
aerobe8412403_aerobe
agarose838653_agarose
aggrade1035633aggrade
agone65924553_ag_one
agorae7511203_agorae
agrafe1038093_agrafe
agree65226033_agr_ee
agreed84712503_agreed
anode65021033_a_node
arose55832083_a_rose
barde85330773ba_r_de
cathode1338993cathode
charade13129903cha_rade
corrode101310573corrode
degrade10229903degrade
dragrope1243203dragrope
eagre64315323eagr__e
erode64520993__erode
garote7717943ga_rote
garrote8510103garrote
geode7412593__geode
grade75126093__grade
gride75223583__gride
grody103412063__grody
grope84821613__grope
grove95219333__grove
hade85440193ha___de
hadron102913753hadro_n
hadrons113314303hadrons
haeredes1246333haeredes
hagborn1344953hagborn
hagdon1188283hagdo_n
hagdons1258523hagdons
haggada1353623haggada
hagged124317703hagged_
haggle113511983hag_gle
haggled13359283haggled
hagridden1551623hagridden
hagriders1443553hagriders
hairdo1036433hair_do
hairdos1136823hairdos
haired105117173haired_
halide103417993ha_lide
halloed113314913halloed
haloed104717593ha_loed
hambone1439313hambone
haole84820083ha__ole
hard85443503ha_r_d_
harden105718533ha_r_den
harder105022403ha_r_der
hards96435653ha_r_ds
hardy125622063ha_r_dy
hare76255733ha_r__e
hared95742183ha_red_
harked145422553ha_rked
harmed125218833ha_rmed
harped124418403ha_rped
harried113815533harried
harrow122610773harro_w
harrowed1556263harrowed
harrower1446363harrower
harrows132611033harrows
hatred104814333hatred_
hatreds11307813hatreds
hayrides1536883hayrides
hognose11117243hognose
horde94623053h_or_de
hotrod1048793hotrod_
hotrods1148283hotrods
hydride15257503hydride
joyrode1853303joyrode
kathode1545733kathode
ladrone83611873ladrone
madrone102812663madrone
mangrove1474403mangrove
manrope1138033manrope
outrode82313423outrode
padrone102512073padrone
pagod95013683pag_od_
pagoda10487873pag_oda
pagods105310193pag_ods
parade94720643pa_rade
parody12410093pa_rody
parole84425253pa_role
paygrade1543593paygrade
ramrod936833ramrod_
ramrods1036583ramrods
regrade92612033regrade
rhapsode1443003rhapsode
rode55844303___rode
safrole1037253safrole
saprobe1137333saprobe
sarod65325873sa_rod_
sarodes84216143sa_rodes
sarods74918573sa_rods
strode75215973_strode
tacnode1045083tacnode
tetrode839333tetrode
trode65322853__trode
upgrade11215823upgrade
vagrom1235943vagro_m
wagsome1345213wagsome

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.203880251.2
2DLD Change Limit1340271118.08016587.5
3Display Results1111110.0303700.0
 (SQL Overall)1786911118.31321495.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.