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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
zonal14511685(None) 
azonal1568271azonal
tonal53724301tonal
zoeal144813781zoeal
zona136321961zona_
zonae145116441zonae
zoonal1558081zoonal
agonal7410052agonal
anal48037522_anal
annal56520762annal
atonal6514022atonal
axonal1347652axonal
banal75925992banal
binal75323822binal
bizonal1845562bizonal
boral75831702boral
canal75428042canal
clonal8310912clonal
coal66939252co_al
comal95125132comal
copal95621782copal
coral76033452coral
coxal146116672coxal
domal85619202domal
dona55529632dona_
donas65926472donas
dotal64919622dotal
final83922032final
foal76630922fo_al
focal104917672focal
fontal9313142fontal
goal55829302go_al
gonad75216052gonad
goral65125752goral
honan85319772honan
horal86328682horal
joual12311652joual
local74820272local
loral55927822loral
loyal84513482loyal
modal85919242modal
molal75120342molal
monad85519472monad
monas74732152monas
moral75533432moral
nodal64717792nodal
nona46929062nona_
nonas55126652nonas
nonyl849772nonyl
nopal75517102nopal
notal55221352notal
nounal639812nounal
opal66923522_opal
oral47638122_oral
oval77119522_oval
penal75228372penal
phonal11310382phonal
renal55929512renal
royal85014702royal
sonar56523422sonar
total55321822total
venal85523212venal
vinal85725812vinal
vocal104715642vocal
zeal135530332z_eal
zoa128529992zo_a_
zocalo1735802zocalo
zoea137118422zoea_
zoeae144412482zoeae
zoeas145815612zoeas
zonally1938002zonally
zonary1838792zonary
zonate154114922zonate
zone135231082zon_e
zoned154020262zoned
zoner144520342zoner
zones145528042zones
zonk175018622zon_k
zonks184815172zonks
zonula1537222zonula
zonule1577482zonule
zoril143916692zoril

Search took 2 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.313570897.8
2DLD Change Limit53800821.51635488.1
3Display Results82820.0165125.0
 (SQL Overall)178691821.84596851.5
 
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.