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

254 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
ignore726906(None) 
ignored9226441ignored
ignorer8276101ignorer
ignores8269001ignores
signore8329091signore
gnome84213952_gnome
gore55744962_g_ore
ignite71410582ignite
ignoble1043612ignoble
ignorers9215242ignorers
inure54119052i_nure
ionone6313442ionone
pignora10306362pignora
signor73510352signor_
signora8348502signora
signori8347892signori
signors83410912signors
signory11427522signory
snore55424952_snore
acnode938203acnode
adore65723673_adore
afore85818603_afore
aglare7312423aglare
agnate73314883agnate
agnize16329563agnize
agnomen1036763agnomen
agone65924553ag_one
agora6914333ag_ora
agorae7511203ag_orae
angora71111573angora
anode65021043_anode
anole55330383_anole
antre55224523_antre
ashore9414613ashore
bandore10611633bandore
before11410153before
bighorn1346063bighorn
bore66051333__bore
canoe75627253cano_e
canoer85121073canoer
cenote83715843cenote
centre84316643centre
chore105126763_chore
core67263113__core
crore74922873_crore
denote74118043denote
diagnose1045123diagnose
donor64418193donor_
donors75115793donors
dore56353303__dore
dynode1135023dynode
encore8314773encore
engorge945543engorge
enorm74415643_enorm
enure53520223_enure
figure10258833fig_ure
figwort1448223figwort
fore78351473__fore
frore86218803_frore
furore9410013furore
galore73514863galore
genome94312193genome
genre66016803_genre
geode7412593_geode
ginger84920033ginger
ginner73915823ginner
glare65222953_glare
globe84917013_globe
glory96413293_glory
glove94516293_glove
gloze154815983_gloze
gnar56021383_gnar_
gnarl65115573_gnarl
gnarr64810693_gnarr
gnars66718853_gnars
gnomes93812973_gnomes
gnoses76515163_gnoses
goer56827103_g_oer
gone55639043_g_one
goner66025163_goner
goose65925903_goose
gor47848263_g_or_
gored75227083_g_ored
gores65740373_g_ores
gorge76423893_g_orge
gorm75529393_g_orm
gorp75625903_g_orp
gorse65926813_g_orse
gory86129663_g_ory
grope84821613_grope
grove95219333_grove
gyre84722763_g_yre
hognose11117243hognose
honor85718623honor_
honored11310123honored
honoree10412113honoree
honorer1039673honorer
honors94816793honors
ichor1039483ichor_
ichors11310423ichors
igloo6410493iglo_o
igloos738033igloos
igneous835773igneous
ignify1334513ignify
ignited9137623ignited
igniter8147673igniter
ignites81310583ignites
ignitor8125263ignitor_
ignitors9135513ignitors
ignobly1342873ignobly
ignorable1245333ignorable
ignorami1142863ignorami
ignorance1244583ignorance
ignorant947153ignorant
ignoring1036483ignoring
immure1036033immure
implore11176703implore
impone103011863impone
import102713763import
impose103113053impose
impure1038383impure
inane52820343i_nane
inarm7314423i_narm
inborn8319143inborn
inbred93010403i_nbred
inbye10427063i_nbye
income10712093income
indie63721473i_ndie
indole74516053indole
indorse8108193indorse
indri6310793i_ndri
indue63516673i_ndue
inert53234373i_nert
infare9313083infare
infer84215033i_nfer
inform11310153inform
infra838643i_nfra
ingate73018243ingate
ingle64120433i_ngle
ingot61221063ingo_t
ingoted939183ingoted
ingots7912063ingots
inhere9313713inhere
injure133410863injure
inker94421093i_nker
inkle94515833i_nkle
innage73011573innage
innate63917313innate
inner54920633inner_
inners63919353inners
innerve1056753innerve
inro45920793i_n_ro
inshore1038723inshore
insnare748243insnare
insole63515863insole
insure63416603insure
inter55028493i_nter
intone61115433intone
intort6418923intort
intro54915853i_ntro
inured73114813i_nured
inures63318953i_nures
inurn53712863i_nurn
invoke1336213invoke
inwove12167273inwove
ionise63516943ionise
ionize154613873ionize
ionogen837123ionogen
ionomer939833ionomer
ionones7313883ionones
ire36943173i___re
irone55126363i_rone
ironer64216453ironer
ivory1137373i_vory
ixora1236913i_xora
kore85834163__kore
lanose6313593lanose
lignite81310303lignite
ligure7279473lig_ure
lore45850353__lore
manor78023933manor_
manors84420883manors
manure8313653manure
mignon937953migno_n
mignonne1142913mignonne
mignons1037863mignons
minor74920063minor_
minored10310103minored
minors85117103minors
more67154523__more
node513036883__node
nome66038423__nome
noncore9411953noncore
none45743173__none
nope65934193__nope
nor38048823__nor_
nori47133143__nori
norm66429813__norm
nose46739363__nose
note46239963__note
ogre56320743og__re
ore36661833___ore
pandore10411853pandore
pignoli1045443pignoli
pinole83218783pinole
pore66451263__pore
rebore86625653rebore
retore67630773retore
rewore938030163rewore
rigor62714053rig_or_
rigors72813713rig_ors
score75526743_score
seignory1244163seignory
senor53822803senor_
senora63216163senora
senores73218113senores
senors63620793senors
shore85432653_shore
signage937773signage
signee73617233sign_ee
signer74015633signer_
signers84714443signers
signior835043signior_
signiori943353signiori
signiors944923signiors
signiory1243563signiory
signoras9306553signoras
signories10107853signories
signorine1045173signorine
snare54429983_snare
snored74819543_snored
snorer64316763_snorer
snores64324323_snores
snort54833753_snort
sore47059533__sore
splore81611303splore
spore75428593_spore
store56333813_store
swore84920823_swore
tenor53620253tenor_
tenors63217753tenors
tenure6311613tenure
tore47359323__tore
ugsome934783ugsome
upbore10247883upbore
uptore8279453uptore
venire93513693venire
venose9310843venose
vigor92612423vig_or_
vigors102911483vig_ors
whore116018043_whore
wore77144673__wore
yore76335943__yore
zingare1737143zingare

Search took 6 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 Limit1127162544.86023192.6
3Display Results2542540.0932731.2
 (SQL Overall)1786912545.32933531.8
 
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.