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

164 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
heritor1031056(None) 
heritors11310901heritors
aerator7314842aerator
editor738662_editor
genitor837272genitor
hector113312652he_ctor
hereto9313692hereto_
heriot9422342heri_ot
heriots10312062heriots
herstory1446692herstory
inheritor1245632inheritor
servitor1145062servitor
aerators8315613aerators
aerier64823163aeri_er
aeriform1346093aeriform
auditor837313auditor
bettor83612223be_ttor
cerite84724873cerit_e
cerites94823433cerites
chelator1347923chelator
chertier1387873chertier
coeditor1145723coeditor
creator93714443creator
creditor1145903creditor
curator9312213curator
debtor938333de_btor
delator83015033delator
depictor1355513depictor
derider93214973derider
derisory1245163derisory
deriver114213913deriver
deviator1248313deviator
devisor11357043devisor
editors839423_editors
eerier64320023eeri_er
erector93513813_erector
error53712233_er_ror
evertor1038723ever_tor
evictor12346363_evictor
excitor1645993excitor
feretory1447513feretory
ferity122813343ferit_y
fervor1235643fer_vor
fetor81214533fe__tor
genitors937423genitors
gyrator1135723gyrator
harbor11410723har_bor
hardtop1345053hardtop
haricot12311963haricot
havior1248203havi_or
heartier1139103heartier
heater94828303he_ater
hectors123513263he_ctors
hefter124313923he_fter
heftier1337203heftier
heifer1238203he_ifer
heir77523803he_i__r
heirdom1344493heirdom
heister103613623heister
helicon1237643helicon
helio85321193heli_o_
helios94816633heli_os
heliport13117803heliport
helistop1344323helistop
hemipter1545583hemipter
herbier1239593herbier
herbivore17132533herbivore
herbivory20141753herbivory
herder104516463her_der
hereinto1145433hereinto_
hereof123212373her_eof
hereon93914363her_eon
heretic12314833heretic
heritage1246533heritage
heritrix1843903heritrix
hermit11519443hermit__
hermitic1539653hermitic
hermitry1644453hermitry
hermits12312143hermit_s
hero74635783her__o_
heron85025503her__on
heros84930863her__os
hertz174919043her_t_z
hesitator1286023hesitator
horizon1955763horizon
hornito1047073hornito_
hornitos1145393hornitos
horror988723hor_ror
humidor1343533humidor
hurter93915853hur_ter
hydrator1545763hydrator
ignitor8125263ignitor
inheritors1345633inheritors
janitor1436483janitor
lector83514993le_ctor
legator83011133legator
levator10298963levator
mediator1139043mediator
mentor8414363me_ntor
merino8315093merino_
merinos9311983merinos
merit7339183merit__
merited10313853merited
merits8320873merit_s
monitor9310723monitor
negator83010673negator
neritic91314333neritic
nestor63713423ne_stor
operator10310093operator
orator6314533_orator
peridot10514243peridot
perigon1039853perigon
period9314983peri_od
peripter1278753peripter
periti8319953perit_i
peritus9311803peritus
perter84422283per_ter
pretor8315753_pretor
prior74316173_pri_or
reactor93011663reactor
realtor73611353realtor
reciter94117263reciter
rector84019753re_ctor
relator74016373relator
remittor10316553remittor
resistor847673resistor
revisor10388733revisor
rewriter1137923rewriter
rhetor938063rhe__tor
rigor62714053__rigor
rotor55519733__rotor
sartor6313883sar_tor
secretor1045683secretor
sector83415933se_ctor
seisor63712343se_isor
seizor15428533se_izor
senator7313073senator
senior63214053seni_or
servitors1245213servitors
stertor7310093ster_tor
stridor8467393stridor
suitor63311053_suitor
termor84412513ter_mor
territory1245103territory
terror63811733ter_ror
therefor1494453therefor
thereto1038993thereto_
thermidor1542693thermidor
thermistor1553183thermistor
thyristor1542363thyristor
traitor7310123traitor
triter65120593_triter
triton63914893_triton
varistor1146393varistor
vector113212063ve_ctor
verditer1236223verditer
verier94620963veri_er
veritas103012753veritas
verite94323443verit_e
verites103822263verites
verity123714853verit_y
visitor1046203visitor
whereto1346063whereto_
writer94416513_writer

Search took 7 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.390458182.1
2DLD Change Limit1340271646.18621666.2
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.63926915.3
 
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.