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

175 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
invader1114645(None) 
invade10157851invade_
invaded12127041invaded
invaders12105301invaders
invades11118291invades
evader1036812_evader
inaner62213542in_aner
inhaler1068052inhaler
inlander937222inlander
inlayer1036932inlayer
insaner7310442insaner
insider849732insider
invar839512inva__r
inviter104112312inviter
invoker1435362invoker
kneader1275892kneader
abrader1038643abrader
anadem939183an_adem
beader94623793_beader
binder94422873bin__der
blader93618583_blader
broader103412613broader
canvaser13276553canvaser
cinder94119123cin__der
deader84220473_deader
divider12278953divider
encoder1038633encoder
ender64325863en__der
engager9278603engager
envier939673env_ier
evade938183_evade_
evaded1137063_evaded
evaders1136933_evaders
evades1039023_evades
fader94421513__fader
finder104020233fin__der
gnawer10386953gn_awer
grader84919693_grader
header104422543_header
hinder104120063hin__der
imager9108123i_mager
impaler11298393impaler
impeder12438533impeder
inane52820343in_ane_
inanes62519803in_anes
incage93513623incage_
incaged114010443incaged
incages103013883incages
incase83615283incase_
incased103612393incased
incases93615973incases
incher114114033in_cher
inciter93113773inciter
incomer1169943incomer
incudes10319523incudes
index13310983in__dex
indexer15287253indexer
inditer83514233inditer
inducer10318763inducer
infare9313083infare_
infares10313023infares
infer84215033in__fer
infidel1146043infidel
inflamer1356123inflamer
inflater1149893inflater
infolder1256433infolder
infuser10298323infuser
ingate73018243ingate_
ingates82716913ingates
ingather1244783ingather
inhale9411513inhale_
inhaled1169333inhaled
inhalers1166643inhalers
inhales10511863inhales
inhauler1163943inhauler
inholder1276113inholder
inhumer1275383inhumer
injurer14318473injurer
inker94421093in__ker
inkier104013783in_kier
inlace82513043inlace_
inlaced10239873inlaced
inlaces92512903inlaces
inlanders1036143inlanders
inlayers1135643inlayers
inlier63615363in_lier
inmate82917363inmate_
inmates92715783inmates
innage73011573innage_
innages82911303innages
innate63917313innate_
inner54920633in__ner
insane6314883insane_
inside7613453inside_
insiders947763insiders
insides8512653insides
insnarer865303insnarer
insurer73312803insurer
intake10510863intake_
intakes11310943intakes
integer837993integer
intender93310443intender
inter55028493in__ter
intoner7811673intoner
intruder945213intruder
invading1336263invading
invalid1146393invalid
invalided1444023invalided
invars9310003inva_rs
inventer112410843inventer
invert94120083inv__ert
inverter112411073inverter
invite93715033invite_
invited113612463invited
invitee103713543invitee
inviters11359643inviters
invites103915813invites
invoke1336213invoke_
invoked1535303invoked
invokers1534673invokers
invokes1436383invokes
involver1444663involver
irade65618153i_rade_
irades74517393i_rades
irater65218353i_rater
islander946103islander
kinder113716843kin__der
kneaded13146473kneaded
kneaders1384713kneaders
lader65633723__lader
leader74824653_leader
loader74316313_loader
minder94822503min__der
nadir61012973_n_adir
namer75622103_n_amer
nearer64618893_nearer
neater64424313_neater
needer73614953_needer
nodder84811943_nodder
nuder66416833_n_uder
onager739663on_ager
parader103914863parader
pervader1444863pervader
pinder94523453pin__der
pleader103511753pleader
ravager1136553ravager
reader73628293_reader
reinvade1244503reinvade_
reinvaded1444073reinvaded
reinvades1344643reinvades
savager1137133savager
shader104218763_shader
snarer64620843sn_arer
sneaker112910453sneaker
snider74413913sn_ider
spader94317133_spader
tinder73821803tin__der
trader75218763_trader
treader84113833treader
under64624213un__der
uneager839753uneager
unevaded1336423unevaded
unfaded123111733unfaded
unjaded16279143unjaded
unlade72714153unlade_
unladed92614373unladed
unladen8248653unladen
unlades82612833unlades
unloader936643unloader
unmade92911063unmade_
unmaker13279513unmaker
vintager12104823vintager
vivider14265623vivider
wader95325363__wader
winder104025263win__der

Search took 9 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.1431249587.4
2DLD Change Limit1340271758.20016344.8
3Display Results1751750.1431223.8
 (SQL Overall)1786911758.48621057.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.