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

207 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
instils781145(None) 
instals7611711instals
instil61111381instil_
instill789061instill
instills867351instills
distils83015802distils
initials848102initials
insouls737212insouls
instal6712192instal_
install779362install
installs858922installs
instars7411132instars
insteps936572insteps
intis55121642in_ti_s
inutile739882inutile
pastils94416172pastils
pistils93314302pistils
abseils935983abseils
ainsells895403ainsells
anils56326723an__ils
antics84621453an_tics
antis55033313an_ti_s
anvils9219713an_vils
apostils1046773apostils
assails769093assails
assoils776663assoils
basils85717473bas_ils
bastile9313913bastile
bastiles10313353bastiles
bestirs9311133bestirs
bustics11810883bustics
dentils84115583dentils
distil73616433distil_
distill83011323distill
distills9319043distills
dossils8669773dossils
dustily113211533dustily
einsteins944153einsteins
ensile62616473ens_ile
ensiles72714833ens_iles
enskies1138573enskies
ensouls736033ensouls
entails7912823entails
entoils7810733entoils
fossils10379013fossils
fusils93912343fus_ils
fustics1279593fustics
fustily133111383fustily
gnostics1146323gnostics
gustily113010903gustily
hastily133010663hastily
hostels103712323hostels
hostile10312553hostile
hostiles11312213hostiles
ignatias944913ignatias
inbuilt947323inbuilt
incites93218483incites
inclips1135963inclips
indies73822783in_dies
indites83618983indites
indols74714203in_dols
indris7311963indri_s
inertias8410383inertias
infalls1038943infalls
infill938413in_fill
inhauls1035523inhauls
initial7311883initial
inosites8312793inosites
inositols943563inositols
insculp1143793insculp
insculps1243393insculps
inseams9307903inseams
insectile1147113insectile
insects93710843insects
inserts74013993inserts
insets64016133ins_ets
inside7613453ins_ide
insides8512653insides
insist6314513ins_ist
insists739083insists
insole63515863ins_ole
insoles73516243insoles
insoul638463insoul_
inspans937803inspans
inspire938253inspire
inspires1037623inspires
instable10313203instable
instant7815353instant
instants8910153instants
instar6310013inst_ar
instate71616483instate
instates81615833instates
instead836203instead
instep838193inst_ep
instilled1045303instilled
instiller944953instiller
instillers1043663instillers
instinct1048723instinct
instincts1144533instincts
insulin738483insulin
insulins848863insulins
insult62813673ins_ult
insults7268963insults
insures73117263insures
inters64328053in_ters
inti46626083in_ti__
intima81910033in_tima
intimas9119583in_timas
intime81014273in_time
intine61021983in_tine
intines7921113in_tines
intitle7610583in_title
intitles8710003in_titles
intros64215773in_tros
intuits7310313intuits
inulins7311493inulins
invites103915813invites
inwalls1037283inwalls
iritis63113733iriti_s
isatins7310773isatins
isseis638563issei_s
istle52214713i_st_le
istles62814983i_stles
kinetics14207253kinetics
kinetins12228153kinetins
kinships1745793kinships
lentils73912973lentils
lintels73311163lin_tels
lintols7339553lin_tols
listels74212433listels
lustily103611243lustily
mainsails1144853mainsails
mastics112614783mastics
minsters103813923minsters
minstrels1145693minstrels
mistily122612343mistily
mustily123613633mustily
mystics14279103mystics
nails55730403_n_ails
nasties73520493nasties
nastily103011033nastily
nifties102612503nifties
niftily1335753niftily
nihils937573_nihils
nils46132463_n__ils
nineties8312923nineties
niseis63512023nisei_s
nitrils72810703nitrils
noils55024333_n_oils
nostrils848183nostrils
pastels95215183pastels
pasties94529813pasties
pastil85018323pastil_
pastis84924323pasti_s
pensils92811593pens_ils
pigsties1139783pigsties
pinitols1046103pinitols
pintails10310163pintails
pistil83915073pistil_
pistols93213983pistols
pontils9312213pontils
postals93716383postals
posties93128813posties
postins93721203postins
ramtils938413ramtils
resails74616743resails
ringtails1044443ringtails
rustics9810733rustics
rustily103112993rustily
sails55738103__sails
snails64816653sn_ails
soils55327983__soils
sties55132983__sties
stile54931573__stile
stiles64328773__stiles
still54922083__still
stills64118573__stills
stilt54831983__stilt
stilts67915313__stilts
stirs55921623__stirs
tastily103311643tastily
testily102910803testily
testis64916713testi_s
tils45739623___tils
tinfoils1144323tinfoils
tinsels738373tins_els
tinsnips1043733tinsnips
tonsils7310183tons_ils
uncoils979533uncoils
unities72520153unities
unnails738223unnails
unseals73212583unseals
unsells73210773unsells
unships1237203unships
unspilt938853unspilt
unsteels845793unsteels
unsteps936213unsteps
unstick1338123unstick
unsticks1436233unsticks
unstops936993unstops
unties64326923un_ties
until53517743un_til_
unveils1045753unveils
upstirs935293upstirs
vestals104612333vestals
wingtips1443253wingtips
zestily19167563zestily

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272077.23618522.2
3Display Results2072070.0762723.7
 (SQL Overall)1786912077.71823152.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.