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

387 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
insist631451(None) 
insists739081insists
assist6314602assist
consist9316032consist
desist74818812desist
enlist6417042enlist
incest82918742incest
incise83515332incise
indict93115572indict
infest93315432infest
ingest73119002ingest
inkiest113415042inkiest
inmost8411362inmost
insect83916582insect
insert64325252insert
inset54430862ins_et
insets64016132insets
inside7613452inside
insight1137912insight
insisted998672insisted
insister888782insister
insult62813672insult
intis55121642intis_
intwist1038042intwist
invest93014842invest
neist54628442_neist
resist64524532resist
ageist7315383ageist
agist66325583_agist
alist56136783_alist
anenst63514983anenst
angst6415493an_gst
animist93815173animist
anis45746463an_is_
anise55129703an_ise
anoint6423633anoint
antis55033313antis_
antsiest8511463antsiest
aorist64827873aorist
apsis75718293apsis_
arsis55722423arsis_
artist64125543artist
assists738473assists
aurist65027253aurist
autist64324943autist
basest84720493basest
basis75429863basis_
bassist9312743bassist
bemist105216963bemist
biblist11310833biblist
bindis94614583bindis_
binit76431583bin_i_t
binits85716673bin_its
bitsiest102610063bitsiest
bundist10310193bundist
busiest93716303busiest
casuist9411303casuist
cineast9310523cineast
cist67244963__cist
consists10310593consists
cosiest93819853cosiest
cosmist11311333cosmist
cubist104214443cubist
deist64633593_deist
delist74625053delist
densest83112473densest
dentist8316743dentist
desists83611723desists
dialist8517763dialist
diarist8517113diarist
diesis74013493diesis_
dingiest102915373dingiest
dinkiest133812873dinkiest
ditsiest92111323ditsiest
easiest72318773easiest
egoist7612283egoist
encyst1136203encyst
engirt71112613engirt
enlists749393enlists
enosis63816423enosis_
ensign737523ensign
ensile62616473ensile
entwist1048803entwist
exist124618943_exist
fascist1239213fascist
feist86230073_feist
fideist1139753fideist
finalist113014733finalist
finest94321733fin_est
finfish16268193finfish
finis86824263fin_is_
finish124613413fin_ish
finniest113011403finniest
fist76248423__fist
foist85730973_foist
ginniest92610513ginniest
gist56046763__gist
gneiss765953gneiss
gnomist1049133gnomist
gnosis75711213gnosis_
grist65529873_grist
heist87030913_heist
hinkiest153311753hinkiest
hissiest112911093hissiest
hist76551543__hist
hoist86433213_hoist
holist94723213holist
ibis66519583i_bis_
iciest82914743iciest
ickiest133611043ickiest
idiot6718863i_diot
idlest74014863idlest
idylist1146653idylist
iffiest1337963iffiest
illest63615723illest
imagist1077333imagist
impis96213853impis_
impish13499193impish
impost103011783impost
inanest72115363inanest
inapt73522693in_apt
inbuilt947323inbuilt
inburst937163inburst
incant82418513incant
incase83615283incase
incent83320723incent
incept102712753incept
incests92711383incests
incipit1158923incipit
incisal947373incisal
incised102911583incised
incises93414893incises
incisor955323incisor
incite83618733incite
incrust949203incrust
incult82414773incult
incus73315053incus_
incuse83513573incuse
indent73021243indent
indicts103210723indicts
indie63721473indi_e
indies73822783indies
indign8308473indign
indigo8388023indigo
indite73520323indite
indium939503indium
indris7311963indris_
induct93212743induct
indult73614033indult
inept73622153in_ept
inert53234373in_ert
inerts64517023inerts
infant92315133infant
infect113413443infect
infests10279793infests
infight1437453infight
infill938413infill
infirm1137043infirm
infix15337773infi_x
inflict1248623inflict
infos84311673infos_
infuse93110573infuse
ingesta8357863ingesta
ingests83210983ingests
ingot61221063in_got
ingots7912063ingots
inhibit1246883inhibit
inia45024703in_i_a
inion54620183in_ion
inject153210233inject
inkier104013783inkier
inking115119053inking
inkjet1737453inkjet
inkpot1237813inkpot
inks86926503in_ks_
inlet53732403in_let
inlets63915573inlets
inlier63615363inlier
inmesh1134863inmesh
inning73617633inning
inns46920933in_ns_
inosine7314283inosine
inosite7314063inosite
input7314653in_put
inputs837703inputs
inquest1638603inquest
inquiet16311413inquiet
inrush936513inrush
ins35945603in__s_
insane6314893insane
insanest8410343insanest
inseam8329993inseam
insects93710843insects
inserts74013993inserts
insider849733insider
insides8512653insides
insights1245493insights
insigne837673insigne
insipid1044513insipid
insistent948253insistent
insisters997653insisters
insisting1038823insisting
insole63515863insole
insoul638463insoul
inspan837513inspan
inspect1138463inspect
inspire938253inspire
inspirit1046283inspirit
instal6712193instal
instant7815353instant
instar6310013instar
instate71616483instate
instep838193instep
instil61111383instil
instill789063instill
instils7811453instils
instinct1048723instinct
insults7268963insults
insure63416603insure
inswept1245733inswept
intact8314663intact
intent63122773intent
inti46626083inti__
intima81910033intima
intime81014273intime
intimist10410213intimist
intine61021983intine
intort6418923intort
intrust7311493intrust
intuit6314083intuit
intuits7310313intuits
intwists1145593intwists
invent93316363invent
invert94120083invert
invests10319683invests
invite93715033invite
inwind10268413inwind
iodise74214943iodise
iodism93611133iodism
ionise63516943ionise
iris45732553i_ris_
ironist7314843ironist
islet54527553i_slet
isms66213473i_sms_
isseis638563isseis_
iwis77117013i_wis_
jingoist16126263jingoist
jinnis13489053jinnis_
joist125125653_joist
jurist134616393jurist
kindest12311503kindest
kinesis11259593kinesis_
kinkiest113110503kinkiest
kist86540803__kist
knish1238603kn_ish
knit85728143kn_i_t
knits93914743kn_its
legist71315253legist
lingiest93715263lingiest
linguist948573linguist
liniest73321153liniest
lintiest82715913lintiest
list47055343__list
lutist64317553lutist
lyrist9312293lyrist
lysis84511463lysis_
maist75535683_maist
midlist10312513midlist
minciest122913113minciest
mingiest113315823mingiest
minis75432993min_is_
minish115216303min_ish
mintiest103217143mintiest
minxish1936213minxish
miosis83615163miosis_
missis84417503missis_
mist66154533__mist
moist76033583_moist
monist84324983monist
mysost1138263mysost
nest45548733_n_est
nicest82315663nicest
niseis63512023niseis_
nisi45823243_n_isi
nisus56014393nisus_
nit37065943_n_i_t
nits45741643_n_its
noise55723733_noise
noisy86813363_noisy
nosiest73415673nosiest
nudist73813323nudist
oasis56422553oasis_
oboist8312683oboist
odist6421913_odist
onanist7314633onanist
onset54730173ons_et
onsets64013543onsets
onside7511803onside
papist102618743papist
persist9315853persist
pianist9615103pianist
pietist9414033pietist
pinfish15319303pinfish
piniest93121133piniest
pinkest132812623pinkest
pinkish16279113pinkish
posit75833333posi_t
posits85718713posits
psis68120343_psis_
psst66118403_ps_st
purist85525053purist
racist82822793racist
rapist82520673rapist
relist64628413relist
resift94017723resift
resists74414923resists
resit54241043resi_t
resits64725563resits
rinses64720383rinses_
rinsing82516113rinsing
rosiest73919213rosiest
sadist74221353sadist
schist11312653schist
sexist133013483sexist
shist84829613_shist
sift710740663__sift
silt46558193__silt
sis37360543__sis_
sissiest83412353sissiest
sit35877753__si_t
sits45050203__sits
snit46342473sn_i_t
snits54124833sn_its
sonsiest8313033sonsiest
subsist9311573subsist
tanist6324593tanist
tennist72813113tennist
tensest72713313tensest
theist9314763theist
tiniest73020123tiniest
tinniest82911463tinniest
tipsiest10228953tipsiest
titlist7312923titlist
tubist83013163tubist
twist86820983_twist
typist1139823typist
unais53420773unais_
uncast84215713uncast
unfit84518563unfi_t
unfits93910293unfits
unfixt16398423unfixt
ungirt71112713ungirt
unit45140073un_i_t
units54923433un_its
unjust1337873unjust
unlit55025463unli_t
unmixt15378703unmixt
unrest62918853unrest
unseat64221023unseat
unsent63820963unsent
unset54532433uns_et
unsets64116163unsets
unshift1387423unshift
unshut939013unshut
unsight1137483unsight
unspilt938853unspilt
untwist1047713untwist
unwise9510803unwise
unwish1239093unwish
unwit84417523unwi_t
unwits9389893unwits
verist93823893verist
vibist11610583vibist
viniest103216613viniest
violist10312143violist
visit8320963visi_t
visits9311423visits
waist86132383_waist
whist115322953_whist
windiest122213233windiest
wingiest123214283wingiest
winiest103419693winiest
winish124212263win_ish
wisest95016443wisest
wist78049293__wist
wrist84827563_wrist
zingiest182810893zingiest

Search took 7 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.376475242.0
2DLD Change Limit1127163875.56020272.7
3Display Results3873870.1263071.4
 (SQL Overall)1786913876.06229477.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.