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

124 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
agnizing193683(None) 
agenizing2046331agenizing
agonizing2047141agonizing
agatizing2087472agatizing
agonising1146572agonising
cognizing2247172cognizing
igniting1037362igniting
ionizing1839502ionizing
paganizing2347272paganizing
abiding11510503a_biding
admiring1236133admiring
admixing1944133admixing
advising1336153advising
adzing174110013a__dzing
affixing2264333affixing
ageing84213403ag__eing
agenting1039383agenting
aging77026353ag___ing
agisting1038243agisting
agnize16329563agniz__e
agnized18247223agniz_ed
agnizes17328843agniz_es
agnomina1144263agnomina
agonizingly2561623agonizingly
agreeing10295903agreeing
aiding84423613a__iding
ailing74331013a__iling
aiming94320843a__iming
airing74927503a__iring
alining81917043a_lining
amazing1938813a_mazing
aneling82719503a_neling
angeling102811733angeling
angering102113803angering
angling92816043a_ngling
anilin6417793a_nilin_
aniline7418473a_niline
anilins7416793a_nilins
ankling122912063a_nkling
annexing1635473annexing
annoying1246543annoying
anodizing2046873anodizing
anteing8312813a_nteing
antiking13412073antiking
anting75827023a_n_ting
anviling1239743anviling
apprizing2347193apprizing
arabizing2147963arabizing
arising83619973a_rising
arriving1237363arriving
aspiring1138873aspiring
atomizing2148513atomizing
attiring939483attiring
auditing1039033auditing
availing1267283availing
avianizing2345553avianizing
avoiding1336783avoiding
awaiting1238273awaiting
awning105013393awn__ing
azotizing1846013azotizing
bagpiping1741913bagpiping
baptizing2345843baptizing
canonizing2247713canonizing
caponizing2446983caponizing
capsizing2345833capsizing
cognising1347043cognising
ebonizing2146823ebonizing
engining1039293engining
finiking16277073finiking
frizing203310873_frizing
gaining94015663_gaining
gaiting93716583_gaiting
ganging103216193gan_ging
gangling112411403gangling
gazing174717173_g_azing
gibing103712353_g_ibing
gieing83614853_g_ieing
ginning93313983_ginning
giving114313883_g_iving
glazing183611003_glazing
gliding103911843_gliding
gliming113310133_gliming
glitzing1934973_glitzing
glozing18338893_glozing
gnawing12377903_gnawing
grazing183514553_grazing
griding103014973_griding
griming113612493_griming
griping113012063_griping
guiding102911843_guiding
guiling93214213_guiling
guising93511413_guising
hagriding1544733hagriding
ignifying1744313ignifying
ignoring1036483ignoring
iodizing1936673iodizing
ionising9310223ionising
ironizing1947933ironizing
japanizing2945153japanizing
jargonizing2944193jargonizing
knifing1536483_knifing
kyanizing2644243kyanizing
laicizing2145713laicizing
latinizing2048123latinizing
leniting9312353leniting
lionizing1947053lionizing
magnetizing2454403magnetizing
magnifying2044033magnifying
niding83217983__niding
nixing143311493__nixing
organizing2146833organizing
ozonizing1845293ozonizing
paganising1445953paganising
patinizing2248613patinizing
prizing193514683_prizing
resizing182714163resizing
salinizing2047433salinizing
seizing174114833_seizing
sizing163616443__sizing
sniping103712053_sniping
ungazing1936033ungazing
ungiving1346333ungiving
uniting8315823_uniting
upsizing2035413upsizing

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621247.45319611.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.65523343.0
 
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.