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 “azine” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
azine14672141(None) 
aline57243151aline
amine75835381amine
azide155617161azide
azines155517071azines
zine137036151_zine
abide86223712abide
acing87429152acing
acini75718982acini
acne66625872a_cne
adzing174110012adzing
aedine73218392aedine
affine12310502affine
afire86215912afire
agene65621582agene
agile65122262agile
agin56132712agin_
aging77026352aging
agone65924552agone
ahing98928342ahing
aide56044992a_ide
ain37579092a_in_
ains46158882a_ins
akene95818662akene
akin86328032akin_
alane56135612alane
alien56425582alien
alike95523962alike
alined75221402alined
aliner65621982aliner
alines65735222alines
alive85722512alive
alkine104916802alkine
alone55732962alone
alpine84417372alpine
alvine94614582alvine
amice96122872amice
amide86128482amide
amie66339852ami_e
amin66042252amin_
amines84727982amines
amino75425502amino
amins75534322amins
ammine10314492ammine
ane37866942a__ne
anile54634462anile
anime75423202anime
anise55129702anise
aping87327232aping
arene55329412arene
arise56436432arise
arsine64021042arsine
aside65122082aside
atone56527982atone
awing96827322awing
axile126020512axile
axing138521372axing
axite125218252axite
axone125918472axone
ayin76331742ayin_
ayins85321612ayins
azan136521782azan_
azans146516882azans
azides165113802azides
azido155411542azido
azole145118032azole
azon135725052azon_
azons146518252azons
azote144416342azote
azure14911482azure
bine66650862_bine
brine75132272brine
canine83826702canine
chine105231722chine
cine66242942_cine
cline76428532cline
dazing175516512dazing
diazine1738932diazine
dine55555332_dine
dwine95616142dwine
exine125518492exine
famine114318192famine
fanzine1937122fanzine
fazing194418642fazing
fine75147952_fine
gamine94620152gamine
gazing174717172gazing
gwine95513662gwine
hazing194218552hazing
imine75821062imine
kine85643422_kine
koine9516482koine
larine63927042larine
lawine93316462lawine
lazing164821472lazing
line46965572_line
maline84529082maline
marine84230402marine
mazing184418972mazing
mine67256162_mine
narine63422552narine
nine45842172_nine
opine77422462opine
ovine86316642ovine
oxazine2354772oxazine
ozone14310612ozone
patine85328122patine
pine67755712_pine
rapine85023082rapine
ratine65131822ratine
ravine95522222ravine
razing164524542razing
sabine84020392sabine
saline65132702saline
savine94220282savine
seine55732872seine
shine85533092shine
sine46560622_sine
sozine15712342sozine
spine76534422spine
swine85625302swine
thine85026852thine
tine45855132_tine
trine54734602trine
twine85822362twine
urine55026592urine
vahine123612112vahine
valine94623092valine
vine75643682_vine
wahine123813012wahine
whine116022812whine
wine74953422_wine
zaire14311992zaire
zin125643772_zin_
zinc156819092_zinc
zineb165614142_zineb
zines145232652_zines
zing145728612_zing
zins135735002_zins
zone135231082_zone

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 Filter178691538000.190940478.9
2DLD Change Limit538001403.62314849.6
3Display Results1401400.0931505.4
 (SQL Overall)1786911403.90645747.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.