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

254 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
inserted9241305(None) 
inserter82312131inserter
insetted9249021insetted
inverted122312161inverted
asserted957902asserted
deserted101012202deserted
disserted11109802disserted
enserfed1245192enserfed
exserted1636212exserted
incented112412542incented
incepted13177772incepted
indebted12246872indebted
indented101811732indented
infected14229402infected
inferred12248352inferred
infested12249642infested
ingested10259002ingested
inhered11313162inher_ed
inherited1348792inherited
injected18226752injected
innerved1246292innerved
insert64325252insert__
inserters92210282inserters
inserts74013992insert_s
insetter8218592insetter
insisted998672insisted
inspected1445402inspected
instated91613342instated
insulted937192insulted
insured83714252insur_ed
interbed112413102interbed
interned93016652interned
interred92615262interred
intorted9310122intorted
invected14258872invected
invented122510662invented
inversed12269282inversed
inverter112411072inverter
invested12229692invested
reinserted1146682reinserted
unseated91317682unseated
unserved12410232unserved
unsorted9312512unsorted
absented1156613absented
adverted1336103adverted
alerted82512223_alerted
angered93013473anger_ed
ansated84214003ans_ated
answered1235483answer_ed
assented957513assented
asserter877563asserter
assorted956593assorted
averted112211613_averted
bisected1336203bisected
caseated11310713caseated
cindered1239793cinder_ed
concerted14312113concerted
consented12311943consented
conserved1538843conserved
consorted1239773consorted
converted15311563converted
deserter91211603deserter
deserved13108133deserved
disseated11711073disseated
dissected13108653dissected
dissented1199713dissented
disserved14107003disserved
diverted13199583diverted
ensured83512943ensur_ed
entered82718883enter_ed
everted112711853_everted
exerted152210053_exerted
experted1838053experted
exsected1835673exsected
fingered13128333finger_ed
gingered11127743ginger_ed
hindered1339453hinder_ed
ideated9310973i_deated
immerged1444023immerged
immersed1344833immersed
imparted13248063imparted
imported13308693imported
inarmed10268673in_armed
inbred93010403in_br_ed
inbreed10267643in_breed
incanted11259543incanted
incensed11277953incensed
incenter102212093incenter
incited103314623in_cited
incurred1136493incurred
incurved1435313incurved
indeed83913563inde__ed
indenter92311443indenter
indexed16347363inde_xed
indicted1249203indicted
indited93515023in_dited
indorsed1066123indorsed
inducted1237273inducted
indurated1139013indurated
inearthed1343623inearthed
inedited10278993inedited
inert53234373in_ert__
inertia7410203in_ertia
inertly1038543in_ertly
inerts64517023in_ert_s
infarcted1544243infarcted
infecter13229153infecter
inferrer11217443inferrer
infester11239433infester
infirmed14205343infirmed
inflated12410863inflated
inflected1546053inflected
informed14197673informed
ingoted939183in_goted
inhere9313713inher_e_
inheres10315173inher_es
injured15339063injur_ed
inmeshed1444483inmeshed
innervated1445463innervated
innerve1056743innerve_
innerves1158013innerves
inputted1134663inputted
inscribed1444213inscribed
insect83916583insect__
insectan1045383insectan
insects93710843insect_s
inserting10914233inserting
insertion9410593insertion
inset54430863inse_t__
insets64016133inse_t_s
insetters9187133insetters
insheathed17173073insheathed
inshrined1344423inshrined
insister888783insister
insnared956123insnared
insolated1039713insolated
insouled936113insouled
insphered1564783inspher_ed
inspired1136273inspired
inspirited1343703inspirited
instarred1043963instarred
instate71616483instate_
instates81615833instates
instead836203ins__tead
instep838193ins__tep
instructed1345633instructed
insulated10310713insulated
insulter836883insulter
insure63416603insur_e_
insureds9277613insur_eds
insurer73312803insur_er
insures73117263insur_es
inswathed1642963inswathed
integrated1289283integrated
intended102310413intended
interacted13411213interacted
interbeds12238903interbeds
interbred1248743interbred
intercede121210983intercede
interested11410333interested
interlend10310113interlend
interne73218143interne_
internee82718513internee
internes82721233internes
interpled1239603interpled
interrex15249823interrex
intersex15209733intersex
interterm1148813interterm
intertie8317613intertie
interties9320333interties
intreated10312663intreated
intuited938763intuited
inturned9268313inturned
inured73114813in_ur_ed
inurned8328053in_urned
inventer112410843inventer
inverse10249643inverse_
inverses112410983inverses
invert94120083invert__
inverters12239753inverters
invertin11910233invertin
invertor11238963invertor
inverts103211953invert_s
invited113612463in_vited
inweaved1534193inweaved
isleted837523i_sleted
iterated91213813i_terated
lineated9711063lin_eated
lingered10129643linger_ed
linseed838203linse__ed
minareted1244623minareted
misseated12610113misseated
missorted1247033missorted
nerved104111683_n_erved
nested74720063_n_ested
netted74118713_n_etted
observed1444373observed
obverted1435103obverted
pinsetter1145013pinsetter
preinserted1443773preinserted
reseated93220263reseated
resected112514743resected
resented92716963resented
reserved121010583reserved
resorted9313493resorted
reverted122714713reverted
seated75131053__seated
sered65737293__ser_ed
serged84118763__serged
served104616813__served
sintered92213903sinter_ed
sneered83113973sneer_ed
snorted83813493sn_orted
sorted74523713__sorted
tinkered1387683tinker_ed
tinseled935763tinse_led
tinselled1044413tinselled
unalerted1047963unalerted
unaverted1336563unaverted
unbelted1179333unbelted
uncarted11312053uncarted
undented102313953undented
underfed13311713underfed
unfelted1279403unfelted
unheated121514553unheated
unletted9310313unletted
unmelted1169183unmelted
unmerited1239643unmerited
unnerved1248063unnerved
unparted11310823unparted
unrented92413923unrented
unrested91914513unrested
unsalted9510923unsalted
unsated83419933uns_ated
unscented1237513unscented
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseeded1038253unseeded
unseized1838443unseized
unsettled1055213unsettled
unsewed112911023unse_wed
unsexed152410253unse_xed
unshirted13105953unshirted
unsifted12128773unsifted
unstated91615813unstated
unsuited9310793unsuited
untented92613413untented
untested92612413untested
unversed122310433unversed
unvested122210223unvested
unwetted1238123unwetted
wintered122111573winter_ed
winterfed1644993winterfed

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.1731032896.0
2DLD Change Limit1461622547.01620832.7
3Display Results2542540.0932731.2
 (SQL Overall)1786912547.28224538.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.