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

117 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
inherit1031297(None) 
inherits11310101inherits
disherit12412522disherit
inert53234372in_er_t
inhabit1277402inhabit
inhere9313712inher_e
inhered11313162inhered
inherent11412792inherent
inheres10315172inheres
inhering12913712inhering
inherited1348792inherited
inheritor1245632inheritor
inhibit1246882inhibit
insert64325252inser_t
interim9912872interim
intermit101213592intermit
inverity1447962inverity
invert94120082inver_t
ankerite1248923ankerite
antherid12611093antherid
chert105232103_cher_t
cinerin9313823cin_erin
demerit10314993demerit
dineric10310973din_eric
disherits1348233disherits
disinherit1455503disinherit
enteric9314213enteric
etheric12311783etheric
heriot9422343__heriot
hermit11519443__hermit
icteric1138023icteric
imperia1148423imperia
imperil1147683imperil
inburst937163inburst
incent83320723ince_nt
incept102712753ince_pt
incest82918743ince_st
incher114114033incher__
inchers123912523incher_s
incipit1158923incipit
indent73021243inde_nt
indri6310793in_dri_
indris7311963in_dris
inedita846793in_edita
inept73622153in_e_pt
inertia7410203in_ertia
inerts64517023in_erts
infarct1249013infarct
infect113413443infe_ct
infer84215033infer__
inferior1156423inferior
inferno1045603inferno
infers93615443infer_s
infest93315433infe_st
ingest73119003inge_st
inhabits1355473inhabits
inheriting1448853inheriting
inheritors1345633inheritors
inheritrix2051553inheritrix
inhesion11116373inhesion
inhibin1244853inhibin
inhibits1345203inhibits
inject153210233inje_ct
inker94421093inker__
inkers104018833inker_s
inlet53732403inle__t
inner54920633inner__
innerly1037133innerly
inners63919353inner_s
innerve1056753innerve
insect83916583inse_ct
inserts74013993inserts
inset54430863inse__t
inspirit1046283inspirit
integrity1345173integrity
intent63122773inte_nt
inter55028493inter__
interact10316473interact
intercity14410003intercity
intercut10411113intercut
interdict12410213interdict
interest8319183interest
interims101013073interims
interior8513093interior
interknit1358333interknit
intermat101114613intermat
intermits111212203intermits
intermix17156873intermix
intern64016543inter_n
interne73218153interne
internist9414883internist
interns73116773interns
inters64328053inter_s
intertie8317613intertie
interunit959833interunit
intort6418923intor_t
intreat7416303intreat
introit7414533introit
intuit6314083in_tuit
invent93316363inve_nt
inverse10249643inverse
invertin11910233invertin
inverts103211953inverts
invest93014843inve_st
ither84617603ither__
lingerie959203lingerie
merit7339183__merit
niterie7313743niterie
sherif122915243_sherif
sincerity1445143sincerity
spheric14510073spheric
thermit12312013_thermit
underlit91311533underlit
unheroic1345263unheroic
unhurt9311253unhur_t
witherite1546693witherite
zitherist2146603zitherist

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271176.75019855.9
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.18924856.2
 
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.