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

288 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
invade1015785(None) 
invaded12127041invaded
invader11146451invader
invades11118291invades
evade938182_evade
inane52820342in_ane
incage93513622incage
incase83615282incase
infare9313082infare
ingate73018242ingate
inhale9411522inhale
inlace82513042inlace
inmate82917362inmate
innage73011572innage
innate63917312innate
insane6314892insane
inside7613452inside
intake10510862intake
invaders12105302invaders
invar839512inva_r
invars9310002invars
invite93715032invite
invoke1336212invoke
irade65618152i_rade
reinvade1244502reinvade
unlade72714152unlade
unmade92911062unmade
abrade9313053abrade
alcade91111513alcade
anadem939183an_adem
anlace82513923anlace
anlage72514233anlage
anode65021043an_ode
ansae55720973ansa_e
ansate64517863ansate
antae56828293anta_e
arcade91013643arcade
aubade939223aubade
bade75140893__bade
binate8419773bin_ate
blade85923333_blade
cade76443923__cade
clade85821013_clade
cnidae978143cnidae
comade114415323comade
couvade1335063couvade
decade104216163decade
divide113410893divide
enate54428153en_ate
encage93713503encage
encase83714363encase
encode9310443encode
enface112510353enface
engage82812103engage
enlace82213233enlace
enrage72715073enrage
envied1038833envied
evaded1137063_evaded
evader1036813_evader
evades1039023_evades
facade1238803facade
fade85736353__fade
finale94116763fin_ale
gavage1137193gavage
glade75121963_glade
grade75126093_grade
hade85440203__hade
hexade17438903hexade
ideate7313683ideate
iliad64613463iliad_
iliads7448673iliads
illude7327503illude
image81411293i_mage
imide85716903i_mide
immane1038883immane
impale102811663impale
impede11469623impede
inaner62213543in_aner
inanes62519803in_anes
inapt73522693in_apt
inarm7314423in_arm
inbred93010403inbred
inbye10427063in_bye
incaged114010443incaged
incages103013883incages
incant82418513incant
incased103612393incased
incases93615973incases
inched124514483inched
incise83515333incise
incite83618733incite
include1036083include
income10712093income
incudes10319523incudes
incuse83513573incuse
indaba935633indaba
indeed83913563indeed
indene73215373indene
index13310983in__dex
indie63721473in_die
indite73520323indite
indole74516053indole
induce93811533induce
indue63516673in_due
indued83411653indued
infall939403infall
infamy1435653infamy
infant92315133infant
infante101910883infante
infares10313023infares
infidel1146043infidel
inflame1256963inflame
inflate10312313inflate
infuse93110573infuse
ingates82716913ingates
ingle64120433in_gle
ingrate8715123ingrate
inhaled1169333inhaled
inhaler1068053inhaler
inhales10511863inhales
inhaul936803inhaul
inhere9313713inhere
inhume1196583inhume
inia45024703inia__
injure133410863injure
inked104218523inked_
inkle94515833in_kle
inlaced10239873inlaced
inlaces92512903inlaces
inlaid7310143inlaid
inland7310313inland
inlander937223inlander
inlands838783inlands
inlay85214323inla_y
inlayer1036933inlayer
inlays9389873inlays
inmates92715783inmates
innages82911303innages
innards837153innards
inned64118423inned_
innovate1145643innovate
inphase1245393inphase
inroad737933inroad_
inroads837043inroads
insaner7310443insaner
inscape1138023inscape
insider849733insider
insides8512653insides
insnare748243insnare
insole63515863insole
instate71616483instate
insure63416603insure
intact8314663intact
intakes11310943intakes
intime81014273intime
intine61021983intine
intone61115433intone
intrude837403intrude
inulase739413inulase
inure54119053in_ure
inured73114813inured
invading1336263invading
invalid1146393invalid
invalided1444023invalided
invalids1244743invalids
invasive1444833invasive
invent93316363invent
inverse10249643inverse
invert94120083invert
invest93014843invest
inviable1338523inviable
invited113612463invited
invitee103713543invitee
inviter104112313inviter
invites103915813invites
invocate1347833invocate
invoice12136243invoice
invoked1535303invoked
invoker1435363invoker
invokes1436383invokes
involve1345093involve
inwall938343inwall
inward10310333inward
inwards1138343inwards
inweave1344723inweave
inwove12167273inwove
iodate7313503iodate
iodide84812933iodide
irades74517393i_rades
irate55627983i_rate
ivied94710523i_vied
jade125325453__jade
kinase104210653kin_ase
knave12389463kn_ave
knawe12397883kn_awe
knead10429663knead_
kneaded13146473kneaded
kneader1275893kneader
kneads11357093kneads
lade56345993__lade
lavage1038263lavage
limeade1076123limeade
linage7713403lin_age
lindane839033lindane
lineage878983lineage
lineate7815153lineate
linkage1295963linkage
lovage1037353lovage
made75440253__made
manmade1237963manmade
minae75627723min_a_e
mintage101110123mintage
mismade12129353mismade
nabe66029493_n_abe
nada58022913_n_ada
nae35952743_n_a_e
name65637413_n_ame
nape65230803_n_ape
nave75732313_n_ave
nicad8312613nicad_
nicads938333nicads
nidate7313783nidate
nide55535803_n_ide
nival84915773niva_l
node513036893_n_ode
novae85913123nova_e
noyade1036423noyade
nude56626283_n_ude
onside7511803onside
ovate84214393_ovate
parade94720643parade
pavane114113443pavane
pervade1337023pervade
pesade9311103pesade
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pintada1096083pintada
pintado1096573pintado
pinwale1257843pinwale
pomade113611333pomade
ravage1039303ravage
reinvaded1444073reinvaded
reinvades1344643reinvades
remade94316983remade
rivage1038843rivage
sade55544483__sade
savage10410173savage
savate9313783savate
shade95125583_shade
silvae92811093silva_e
sinkage1287263sinkage
sinuate7412163sinuate
snake94821113sn_ake
snare54429983sn_are
snide64318733sn_ide
spade84423323_spade
stade64825303_stade
tinware1038603tinware
tirade7311693tirade
trade65026043_trade
tsade64311123_tsade
unbale83616403unbale
uncage93014873uncage
uncake122813523uncake
uncase83817433uncase
unde55825493un__de
unease63816643unease
unevaded1336423unevaded
unfaded123111733unfaded
unjaded16279143unjaded
unlace82215173unlace
unladed92614373unladed
unladen8248653unladen
unlades82612833unlades
unmake122811213unmake
unsafe9310693unsafe
untame82513603untame
vale74937343__vale
vane75534693__vane
vase75629653__vase
vide85432773__vide
vintage11128143vintage
vivace1436553vivace
wade85237073__wade
windage1237933windage
zincate1838533zincate
zingare1737143zingare

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.393454684.5
2DLD Change Limit1127162885.53020382.6
3Display Results2882880.0933096.8
 (SQL Overall)1786912886.01629702.6
 
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.