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

150 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
hordeins123832(None) 
hordein1138751hordein_
codeins103715482co_deins
hardens113815022harde_ns
hoddens12378802hodde_ns
hoddins12289372ho_ddins
hoidens11329082hoide_ns
hordes104921632horde__s
hording123517052hord_ing
hoydens14347402hoyde_ns
orceins937742_orceins
ordains879652_ordains
bodkins1438313bo_dkins
bordels103911973borde_ls
bordering1338833bordering
borders104317533borde_rs
boreens9310403bor_eens
boudins10311313boud_ins
burdens1039713burde_ns
chording15410153chord_ing
chortens13308793chorte_ns
codeias103911223co_deias
codein94916723co_dein_
codeina104010323co_deina
codeinas11338023co_deinas
codeine103815033co_deine
codeines113114523co_deines
codens94821013co_de_ns
codlins104116243co_dlins
condemns1336293condemns
corbeils12358073corbeils
corders104520883corde_rs
cording113620823cord_ing
cordings123011353cord_ings
cordons104415763cord_ons
cordwains1544153cordwains
coreigns1136323cor_eigns
cortins92421333cor_tins
croceins1238103croceins
dormins10311273dor_mins
fadeins1168503_fadeins
fording123717043ford_ing
fordoing1357303fordoing
forfeits1445803forfeits
gardens93312093garde_ns
gorgerins1145193gorgerins
gorhens1137183gorhe_ns
harden105718533harde_n_
hardening1438023hardening
hardenings1544243hardenings
hardies114923233hard_ies
hardline12310273hardline
hardpans1436453hardpans
harkens144112863harke_ns
harmins123716723har_mins
harpins123615703har_pins
headpins1436103headpins
herders113914123herde_rs
herdics13249523herd_ics
herding122915123herd_ing
herein93717793her_ein_
heroins103518013her_oins
hirudins1244933hirudins
hoarders12307433hoarde_rs
hoarding13288643hoard_ing
hoardings14315113hoard_ings
hoarsens11306023hoarse_ns
hoatzins2043843hoatzins
hodden113811453hodde_n_
hoddin11369943ho_ddin_
hoedowns15124653hoedowns
hoeing104117023ho__eing
hoiden103612333hoide_n_
hoidening1435633hoidening
holden104113953holde_n_
holders113715903holde_rs
holding123514283hold_ing
holdings13297743hold_ings
holsteins1245263holsteins
hondling132210013hondling
hoodies113419833hood_ies
hooding123815203hood_ing
hoodwink1942903hoodwink
hoodwinks2042073hoodwinks
horde94623053horde___
horded115420483horde__d
hordeola1244733hordeola
horizons2045463horizons
hornets104113553horne_ts
horning113015003hor_ning
hornings12238363hor_nings
horns86125333hor___ns
horrent10313553horre_nt
horsemint1447123horsemint
horsemints1543983horsemints
horses94729343horse__s
horsing113215583hor_sing
howdies142911953howd_ies
howdying1933713howdying
hoyden13328933hoyde_n_
hoydening1744353hoydening
hoydenish1942563hoydenish
hurdies114015663hurd_ies
hurdling13288013hurdling
iodins74216523io_d_ins
jordans1566833jord_ans
lodens74315063lo_de_ns
lomeins969483lo_meins
lording93115233lord_ing
lordings10368503lord_ings
lordling1077743lordling
lordlings1143923lordlings
loudens8368053loude_ns
moderns1037963mo_derns
mordent10313993morde_nt
mordents1138813mordents
moreens939963mor_eens
morgens10310463morge_ns
morphins1538653morphins
mureins9310733mur_eins
narceins1036413narceins
odeons739023_o_deons
oleins6313523_o_leins
oodlins83210513_oodlins
orcein838183_orcein_
orcins83313433_or_cins
ordain7810403_ordain_
ordeals877993_ordeals
ordering1039353_ordering
orders74315993_orde_rs
ordines83014903_ord_ines
origins8310463_origins
orpins83614163_or_pins
osseins736133_osseins
proteins102114283proteins
reins56234563__r_eins
reordains10145453reordains
sereins73716123ser_eins
shortens11288993shorte_ns
soddens9348413sodde_ns
sordine82515233sord_ine
sordines92414073sord_ines
sordini8228963sord_ini
sordino8219443sord_ino
verdins112812333verd_ins
wardens113711903warde_ns
woodbins1445043woodbins
wording123014563word_ing
wordings13328563word_ings
worsens104610263worse_ns

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.420425454.8
2DLD Change Limit1461621507.17320376.7
3Display Results1501500.0463260.9
 (SQL Overall)1786911507.63923391.9
 
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.