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

132 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
inedited1027899(None) 
indited93515021in_dited
unedited10249831unedited
coedited1237832coedited
credited1238252credited
edited83913672__edited
endited93512912en_dited
incited103314622in_cited
indebted12246872indebted
indented101811732indented
indicted1249202in_dicted
indite73520322in_dite_
inditer83514232in_diter
indites83618982in_dites
inedita846792inedit_a
inherited1348792inherited
intuited938762intuited
invited113612462in_vited
misedited1346782misedited
reedited10310082reedited
anodized1946463anodized
antedated1146703antedated
audited939033_audited
benefited1544173benefited
chedite1338863chedite_
chedites1438263chedites
debited113311623_debited
endite73817593en_dite_
endites83717063en_dites
evited104013143__evited
exited144712523__exited
expedited2044933expedited
ideated9310973ide_ated
ignited9137623i_gnited
incanted11259543incanted
incented112412543incented
incepted13177773incepted
incised102911583in_cised
incite83618733in_cite_
inciter93113773in_citer
incites93218483in_cites
inclined1138643inclined
indeed83913563in_d_eed
indenter92311443indenter
indexed16347363in_dexed
indicated13310953in_dicated
indices103513443in_dices
indictee1149623in_dictee
indicter1148143in_dicter
indie63721473in_di_e_
indies73822783in_di_es
indigen9319333in_digen
inditers93311053in_diters
indowed1237443in_dowed
induced11298933in_duced
inducted1237273inducted
indued83411653in_d_ued
inearthed1343623inearthed
inebriated1345473inebriated
inedible1147473inedible
inedibly1445903inedibly
infected14229403infected
infested12249643infested
infixed18206563in_fixed
inflated12410863inflated
inflicted1545533inflicted
ingested10259003ingested
ingoted939183in_goted
inhabited1544673inhabited
inhibited1544763inhibited
initiated10510113initiated
injected18226753injected
inosite7314063inosite_
inosites8312793inosites
inputted1134663inputted
inquieted1944253inquieted
inquired18245933inquired
inserted92413053inserted
insetted9249023insetted
insisted998673insisted
inspired1136273inspired
instated91613343instated
insulted937193insulted
interdicted1546223interdicted
intitled967343in_titled
intorted9310123intorted
intwined1235463intwined
intwisted1344333intwisted
inundated1144753inundated
invected14258883invected
invented122510663invented
inverted122312163inverted
invested12229693invested
invite93715033in_vite_
invitee103713543in_vitee
inviter104112313in_viter
invites103915813in_vites
invoiced1494823invoiced
iodated9310023i_odated
iodised9329243i_odised
iodized18969163i_odized
itemised11105163itemised
itemized20105343itemized
iterated91213823iterated
lenited8812433_lenited
lineated9711063line_ated
mediated123011873_mediated
merited10313853_merited
negated93413233_negated
nested74720063_ne_sted
netted74118713_ne_tted
nidated939863_nidated
precited133013813precited
predated12513273predated
predicted1538913predicted
preedited1337633preedited
recited104319103_recited
redated93120923_redated
resited85122423_resited
sedated93714353_sedated
snedded10377393sned_ded
subedited1345543subedited
unaudited1145853unaudited
uncredited1445003uncredited
undated93118463un_dated
undented102313953undented
unexcited1953983unexcited
united74421543un__ited
unmediated1445163unmediated
unmerited1239643unmerited
unsuited9310793unsuited
ununited938683ununited

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.440406115.9
2DLD Change Limit1461621327.20320291.8
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.68923239.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.