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

235 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
insult6281367(None) 
incult82414771incult
indult73614031indult
insults7268961insults
consult92513632consult
inbuilt947322inbuilt
induct93212742induct
indults8289492indults
ingulf10310352ingulf
input7314652inpu_t
insculp1143792insculp
insect83916582insect
insert64325252insert
inset54430862ins_et
insist6314512insist
insole63515862insole
insoul638462insoul_
insouls737212insouls
insulant849882insulant
insular7138702insular
insulate8312842insulate
insulin738482insulin
insulted937192insulted
insulter836882insulter
insure63416602insure
intuit6314082intuit
result6318222result
adult63520653_adult
ainsell796393ainsell
annul55813383annul_
annulet7311593annulet
annuli6459053annuli
annuls64711733annuls
assault747413assault
basalt83519583basalt
cingula10327173cingula
consul82312303consul_
consuls92412313consuls
consults10219983consults
cult66541153__cult
desalt7518313desalt
englut738453englut
engulf1038883engulf
ensile62616473ensile
ensoul638253ensoul_
ensouls736033ensouls
ensue54013833ensu_e
ensued73610483ensued
ensues63313813ensues
ensure63416003ensure
exult122814123_exult
fault85428313_fault
gault65128483_gault
inapt73522693in_apt
inburst937163inburst
incant82418513incant
incent83320723incent
incept102712753incept
incest82918743incest
incrust949203incrust
incubi1035113incubi
incur72212253incu_r
incurs83012283incurs
incus73315053incu_s
incuse83513573incuse
indent73021243indent
indict93115573indict
indol63714873indol_
indole74516053indole
indols74714203indols
induce93811533induce
inducts10259573inducts
indue63516673indu_e
indued83411653indued
indues73515263indues
indulge945403indulge
indulin838773indulin
indwelt1146513indwelt
inept73622153in_ept
inert53234373in_ert
infall939403infall
infant92315133infant
infect113413443infect
infest93315433infest
infill938413infill
influx1643723influx
infold10128163infold
infuse93110573infuse
ingest73119003ingest
ingle64120433in_gle
ingot61221063in_got
ingulfs1134733ingulfs
inhale9411513inhale
inhaul936803inhaul_
inhauls1035523inhauls
inhume1196583inhume
inject153210233inject
injure133410863injure
injury16266143injury
inkblot1344203inkblot
inkjet1737453inkjet
inkle94515833in_kle
inkpot1237813inkpot
inlet53732403in_let
inly75622213in__ly
inmost8411363inmost
inocula947263inocula
inputs837703inputs
inquest1638603inquest
inquiet16311413inquiet
inrun52911373inru_n
inruns6359513inruns
inrush936513inrush
ins35945603ins___
insane6314893insane
insculps1243393insculps
inseam8329993inseam
insects93710843insects
inserts74013993inserts
insets64016133insets
inside7613453inside
insight1137913insight
insists739083insists
insolate8311893insolate
insolent81311553insolent
insoles73516243insoles
insouled936113insouled
inspan837513inspan
inspect1138463inspect
instal6712193instal
install779363install
instals7611713instals
instant7815353instant
instar6310013instar
instate71616483instate
instep838193instep
instil61111383instil
instill789063instill
instils7811453instils
instruct1047543instruct
insulants946913insulants
insulars8137323insulars
insulated10310713insulated
insulates9311843insulates
insulator948103insulator
insulins848863insulins
insulters945883insulters
insulting1038053insulting
insurant8411433insurant
insured83714253insured
insurer73312803insurer
insures73117263insures
inswept1245733inswept
intact8314663intact
intent63122773intent
intort6418923intort
intrust7311493intrust
intuits7310313intuits
inturn63411563inturn
inulin6311733in_ulin
inure54119053in_ure
inurn53712863in_urn
invent93316363invent
invert94120083invert
invest93014843invest
inwall938343inwall
irrupt846993irrupt
isle45121703i_s_le
islet54527553i_slet
issuant748263issuant
issue559213issu_e
issued746723issued
issuer646623issuer
issues648803issues
istle52214713i_stle
itself946263itself
jesuit1339583jesuit
knelt94617683kn_elt
knout95018263knou_t
lingula8428803lingula
midcult1246303midcult
minuet82621033min_uet
missuit9911303missuit
moult74728723_moult
nisus56014393nisu_s
nonsuit7811343nonsuit
null45125313_n_ull
nut36651963_n_u_t
occult1038433occult
onset54730173ons_et
penult8314653penult
pinnula934913pinnula
pinnule936003pinnule
poult76928873_poult
results739833results
salt45758523__salt
sault55834963_sault
silt46558193__silt
sinful938803sinful_
slut45040593__slut
snout54530633snou_t
suet46754823__suet
suit45649873__suit
sulk85326653__sulk
sulu45128423__sulu
sunsuit748693sunsuit
tinful938043tinful_
tinfuls1036593tinfuls
tinsel639443tinsel_
tinsels738373tinsels
tumult839703tumult
unadult856643unadult
unbelt83015693unbelt
unbolt83013893unbolt
unbuilt948003unbuilt
uncut73219173uncu_t
unduly1037823unduly
unfelt92413463unfelt
ungula737603ungula
unhurt9311253unhurt
unjust1337873unjust
unruly938083unruly
unseat64221023unseat
unsell63512543unsell
unsent63820963unsent
unset54532433uns_et
unshut939013unshut
unsold71410513unsold
unspilt938853unspilt
unsplit956563unsplit
unsung736983unsung
unsunk1036333unsunk
unsure62815413unsure
vault85823763_vault
vincula1246393vincula

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127162354.75023729.7
3Display Results2352350.0932526.9
 (SQL Overall)1786912355.20334343.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.