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 “heired” 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
heired10381304(None) 
haired105117171haired
heiled104415611heiled
hired95226261h_ired
aeried74221872aeried
aired66032922_aired
bemired123410632bemired
ceiled94114952ceiled
cered85227442ce_red
chaired134211242chaired
cheered133713302cheered
choired13349342choired
deaired9411532deaired
deiced104214482deiced
desired9311982desired
eared65139502_eared
erred65915672_erred
faired105915772faired
feared106320432feared
fired94829742_fired
geared85317742geared
hailed104122742hailed
hared95742182h_ared
hatred104814332hatred
headed114020472headed
healed105121442healed
heaped124516902heaped
heard95222752hear_d
hearer94323652hearer
hearsed113811422hearsed
hearted113314032hearted
heated104525592heated
heaved134717862heaved
hedged125211812hedged
heed86437602he__ed
heeded114215762heeded
heeled104018422heeled
heezed194210512heezed
hefted134911422hefted
heifer1238202heifer
heir77523802heir__
heiress1036812heiress
heirs85618562heir_s
heisted113210652heisted
helled104024702helled
helmed124513692helmed
helped124714152helped
helved134313702helved
hemmed144211462hemmed
hented104218752hented
herbed123513452herbed
herd84933062he_r_d
herded114215642herded
here76447102he_re_
heres86245902he_res
herried113514472herried
hewed125619432he_wed
hexed165615762he_xed
hided105222442h_ided
hied85434042h_i_ed
hiked135919202h_iked
hire75538962h_ire_
hiree85427802h_iree
hirer85423122h_irer
hires86134342h_ires
hived125217912h_ived
hoised105117432hoised
ired55131872__ired
jeered143912792jeered
laired75216812laired
leered73816222leered
metred95315142metred
mired85729222_mired
neared75119812neared
paired95017522paired
peered93819492peered
peined94918842peined
peised94817682peised
quired163711952quired
reared75930012reared
rebred95816352rebred
refired115116992refired
rehired115013152rehired
reined74425522reined
reived104518132reived
retired84620142retired
rewired115413282rewired
seared75232842seared
seined74023062seined
seised74218122seised
seized164313652seized
sered65737292se_red
sheared114516012sheared
sheered113515462sheered
sired66134282_sired
speired103811102speired
spired94921862spired
teared75722152teared
tiered73613972tiered
tired65228902_tired
veered103612742veered
veiled103714542veiled
veined104413912veined
waired106015832waired
weird95111282weir_d
weirded1234512weirded
wired95327642_wired

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511072.54632423.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911072.93560882.8
 
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.