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

197 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
insisted99867(None) 
insister888781insister
assisted936232assisted
consisted1238502consisted
desisted1039782desisted
enlisted978192enlisted
incised102911582incis_ed
incited103314622inci_ted
indicted1249202indicted
indited93515022indi_ted
infested12249642infested
ingested10259002ingested
inserted92413052inserted
insetted9249022insetted
insist6314512insist__
insistent948252insistent
insisters997652insisters
insists739082insist_s
instated91613342instated
insulted937192insulted
intwisted1344332intwisted
invested12229692invested
invited113612462invi_ted
resisted9312692resisted
unlisted9311152unlisted
unsifted12128772unsifted
agisted938203_agisted
aniseed839403an_iseed
anointed938343anointed
ansated84214003ans_ated
assister836753assister
bemisted1368383bemisted
cisted95217523__cisted
delisted10310563delisted
encysted1444293encysted
endited93512913endi_ted
enisled82510223en_isled
enlistee868323enlistee
enlister847803enlister
ensiled82611433ensi_led
entwisted1343803entwisted
existed1538473_existed
finished1536483fin_ished
fisted104218703__fisted
foisted113210603_foisted
heisted113210653_heisted
histed104420243__histed
hoisted113411293_hoisted
ignited9137623igni_ted
impasted13297553impasted
imposted13257403imposted
incanted11259543incanted
incased103612393incas_ed
incented112412543incented
incepted13177773incepted
incise83515333incis_e_
incises93414893incis_es
incite83618733inci_te_
inciter93113773inci_ter
incites93218483inci_tes
incrusted12125843incrusted
incused102911173incus_ed
indebted12246873indebted
indented101811733indented
indicated13310953indicated
indictee1149623indictee
indicter1148143indicter
indigested13103673indigested
indite73520323indi_te_
inditer83514233indi_ter
indites83618983indi_tes
inducted1237273inducted
inedited10278993inedited
infected14229403infected
infester11239433infester
infirmed14205343infirmed
infixed18206563infi_xed
inflated12410863inflated
inflicted1545533inflicted
infused11329253infus_ed
ingoted939183in_goted
inhibited1544763inhibited
initiated10510113initiated
injected18226753injected
inmeshed1444483inmeshed
inosite7314063inosi_te_
inosites8312793inosi_tes
inputted1134663inputted
inquieted1944253inquieted
inserter82312133inserter
insetter8218593insetter
inside7613453insi_de_
insider849733insi_der
insides8512653insi_des
insigne837673insigne_
insinuated1144813insinuated
insipid1044513insi_pid
insistence1246013insistence
insistency1553973insistency
insisting1038823insisting
insnared956123insnared
insolated1039713insolated
insouled936113insouled
inspected1445403inspected
inspired1136273inspired
inspirited1343703inspirited
inspissated1451493inspissated
instate71616483instate_
instates81615833instates
instead836203in__stead
instep838193in__step
instigated1247693instigated
instilled1045293instilled
instituted1144943instituted
insulated10310713insulated
insulter836883insulter
insured83714253ins_ured
inswathed1642963inswathed
intimated121010893intimated
intitled967343intitled
intorted9310123intorted
intrusted1076903intrusted
intuited938763intuited
invected14258883invected
invented122510663invented
inverted122312163inverted
inviscid1442303inviscid
invite93715033invi_te_
invitee103713543invi_tee
inviter104112313invi_ter
invites103915813invi_tes
iodised9329243iodis_ed
ionised82911493ionis_ed
irised73913153i_ris_ed
ironfisted1442163ironfisted
isleted837523i_sleted
issued746723i_s_sued
joisted15379173_joisted
knitted12337423kn_itted
listed74322833__listed
minished1437873min_ished
minister10410363min_ister
misted93625823__misted
nested74720063_n_ested
noised75416233_nois_ed
persisted1247143persisted
posited10511493posi_ted
relisted9312623relisted
resifted12310153resifted
resister8311653resister
resited85122423resi_ted
sifted104313673__sifted
silted74020013__silted
sinister838583sin_ister
sister64421583__sister
sited65130743__si_ted
subsisted1245783subsisted
twisted11277433_twisted
unassisted1143833unassisted
unbasted112510073unbasted
unbitted1138213unbitted
unbusted11258773unbusted
unfished15218293unfished
unfitted1238163unfitted
ungifted13116833ungifted
unissued934683unissued
united74421543un_i_ted
unkissed1334893unkissed
unpitted1148623unpitted
unposted1159433unposted
unrested91914513unrested
unrusted92310353unrusted
unsalted9510923unsalted
unsated83419933uns_ated
unseated91317683unseated
unshifted16124943unshifted
unshirted13105953unshirted
unsighted1455433unsighted
unsigned1037563unsigned
unsized172510543unsi_zed
unsorted9312513unsorted
unstated91615813unstated
unstinted1038563unstinted
unsuited9310793unsuited
untasted92011573untasted
untested92612413untested
untilted9610893untilted
untwisted1344863untwisted
unvested122210223unvested
unvisited1345173unvisited
unwasted12259783unwasted
unwished15237833unwished
unwitted1237543unwitted
visited1168773visi_ted
waisted114210943_waisted
whisted144010013_whisted
wisted104120273__wisted

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.420425454.8
2DLD Change Limit1461621977.28320068.9
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.77922970.9
 
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.