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

278 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
agnize1632956(None) 
agenize172910151agenize
agnized18247221agnized
agnizes17328841agnizes
agonize172911401agonize
agatize1739832agatize
agaze156113662ag_aze
agenized19257732agenized
agenizes18269742agenizes
aggie73415012aggi_e
agile65122262ag_ile
agnate73314882agnate
agonise83112692agonise
agonized19258992agonized
agonizes182610582agonizes
anile54634462a_nile
anime75423202a_nime
anise55129702a_nise
assize1538632assize
cognize1957682cognize
ignite71410582ignite
ionize154613872ionize
paganize2048632paganize
abide86223713a_bide
ablaze17239833ablaze
acne66625873acn__e
acnode938193acnode
aconite9315473aconite
active11313743active
adenine8311213adenine
admire949933admire
adnate72913483adnate
adoze155713833a_doze
advice12107883advice
advise10139223advise
adze1412820573a__dze
aedile73716653aedile
aedine73218393aedine
aerie54634603aeri_e
affine12310503affine
afire86215913a_fire
again65218123agai_n
agapae9388043agapae
agape85614843ag_ape
agate66525153ag_ate
agatized1947073agatized
agatizes1838863agatizes
agave95314033ag_ave
age47154333ag___e
agee56241493ag__ee
ageing84213403ageing
ageism968803ageism
ageist7315383ageist
agene65621583ag_ene
agentive1248043agentive
aggies83515513aggies
agin56132713ag_i_n
aging77026353ag_ing
agings86312673agings
aginner844663aginner
agio57828453ag_i_o
agios65919863ag_ios
agism84614063ag_ism
agist66325583ag_ist
agita6315423ag_ita
aglare7312423aglare
aglee65728493ag_lee
agnail739533agnail
agnails837003agnails
agnates82813193agnates
agnizing1936833agnizing
agnomen1036763agnomen
agone65924553ag_one
agonic93515143agoni_c
agonies83016623agonies
agonised10248483agonised
agonises92613163agonises
agonist82615403agonist
agorae7511203agorae
agrafe1038093agrafe
agree65226033ag_ree
agria65517143agri_a
agrias74315393agrias
ague55725923ag__ue
aguish1059283aguish
aide56044993a__ide
alanine7316863alanine
albite8313313albite
alike95523963a_like
aline57243153a_line
alive85722513a_live
alkie95520033alki_e
alkine104916803alkine
alnico877943alnico
alpine84417373alpine
alsike1047913alsike
alunite7311633alunite
alvine94614583alvine
amaze166016603a_maze
amice96122873a_mice
amide86128483a_mide
amie66339853a_mi_e
amine75835383a_mine
ammine10314493ammine
amnia75918643amni_a
amnic95516243amni_c
amnio75218053amni_o
amnion84812053amnion
amnios84912523amnios
amniote936963amniote
ane37866953a_n__e
anele55628833a_nele
angina7413133angina
angle64528873a_ngle
anglice1089213anglice
anguine839913anguine
ani37751183a_ni__
anil46437433a_ni_l
anils56326723a_nils
anima74620073a_nima
animes84719593a_nimes
animi74016663a_nimi
anion55028813a_nion
anis45746463a_ni_s
anises64826693a_nises
ankle95220253a_nkle
annexe1337813annexe
anode65021033a_node
anodize1738673anodize
anole55330373a_nole
ansae55720973a_nsae
antae56828293a_ntae
ante46538903a_n_te
antre55224523a_ntre
aplite8316393aplite
apprize2038183apprize
arabize1849343arabize
arenite71017713arenite
arginine948563arginine
arise56436433a_rise
arnica8310443arnica
arrive91311793arrive
arsine64021043arsine
aside65122083a_side
asinine7310723asinine
aspire8612123aspire
assizes1638453assizes
atomize183111823atomize
attire62412383attire
audile73315303audile
augite7312613augite
auntie64317703auntie
avianize2045723avianize
awhile1257793awhile
awning105013393awning
axile126020513a_xile
axite125218253a_xite
axlike17388853axlike
azide155617163a_zide
azine146721413a_zine
azotize1537083azotize
baggie102912193baggi_e
baglike14338943baglike
bagnio937523bagni_o
bagnios1036073bagnios
bagpipe1453113bagpipe
baize164717393_baize
baptize2036983baptize
bize155926293__bize
bonze165119353bon_ze
braize174113113braize
canine83826703canine
cannie83819363canni_e
canonize1959833canonize
caponize2139113caponize
capsize2037623capsize
carnie84421093carni_e
cognise1059683cognise
cognized2136293cognized
cognizer2055863cognizer
cognizes2058033cognizes
conine84528553conine
denizen1737663denizen
dunite7315013dunite
ebonize1838153ebonize
engine71114863engine
finite9316823finite
gahnite1135973gahnite
gamine94620153gamine
gane55145303gan__e
gangue81310573gangue
gauze155712973_gauze
gaze145032413_g_aze
genie66124923geni_e
gibe75927783_g_ibe
gie47149543_g_i_e
ginzo1539613_ginzo
gite55438613_g_ite
give85829353_g_ive
glaze155418163_glaze
glide74521593_glide
glime85620193_glime
gloze154815983_gloze
gnome84213953_gnome
graze155820053_graze
gride75223583_gride
grime85021323_grime
gripe84622963_gripe
guide75019883_guide
guile64521133_guile
guise64717713_guise
gunite7414403gunite
gwine95513663_gwine
hagride1237553hagride
ignify1334513ignify
ignited9137623ignited
igniter8147673igniter
ignites81310583ignites
ignore7269063ignore
iodize164112593iodize
ionise63516943ionise
ionized172611293ionized
ionizer162310123ionizer
ionizes162813343ionizes
ironize16610373ironize
japanize2645283japanize
jargonize2645293jargonize
kainite1149543kainite
knife1210010133_knife
kyanize23265343kyanize
laicize1838093laicize
latinize17610563latinize
lenite6719983lenite
lignite81310303lignite
lionize1668823lionize
magnate10512703magnate
magnetize21519873magnetize
magnify1634533magnify
magpie1139093magpi_e
maize164618563_maize
mannite9312903mannite
monie75631653moni_e
nannie63713223nanni_e
nice65534713__nice
nide55535783__nide
nine45842173__nine
nite45943583__nite
nixe115722023__nixe
ogive9379093og_ive
organize1849093organize
ozonize1546293ozonize
paganise1139663paganise
paganized2247163paganized
paganizer2145763paganizer
paganizes2148663paganizes
patinize19610773patinize
penile82219603penile
pinite8321243pinite
prize164718943_prize
ragtime1036163ragtime
resize154117723resize
salinize1739683salinize
seize143819503_seize
senile63420213senile
size135630963__size
snide64318723_snide
snipe75320573_snipe
taeniae739083taeniae
taglike12278913taglike
tagline82412453tagline
teniae64517353teniae
unite54828383_unite
upsize17267303upsize
vagile10310543vag_ile
vaginae11377683vaginae
venine93718433venine
venire93513693venire
winze175014853win_ze

Search took 5 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.1231452772.4
2DLD Change Limit1127162784.75023729.7
3Display Results2782780.0962895.8
 (SQL Overall)1786912784.96935961.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.