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

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

98 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
subzones194722(None) 
subtones10311381subtones
subzone1846991subzone_
subcodes1338142subcodes
sublines10315782sublines
subtone9310342subtone_
subvenes1339632subvenes
sulfones1147682sulfones
ambones11312683amb_ones
bizones1837823_bizones
bones76446533__b_ones
buboes104513993bub_o_es
cabezones2243783cabezones
calzones1948763calzones
canzones1939153canzones
debones103315113deb_ones
doblones1136763doblones
duotones937643duotones
evzones1964523_evzones
fuzztones2041543fuzztones
mucrones1237603mucrones
ozones1539393__ozones
quinones17227753quinones
rezones163213943_rezones
sabines94318483sab_ines
sawbones13126643sawbones
scones84521303s__cones
someones1039063someones
sones55444143s___ones
sozines16611263s_ozines
spadones1137253spadones
spumones1254953spumones
stones65130033s__tones
subbases1239063subbases
subbings13238483subbings
subcode1237163subcode_
subcools1245753subcools
subcutes1238583subcutes
subduces1397263subduces
subdues1099893sub_dues
subfiles131710723subfiles
subfixes20207493subfixes
subgenres1245533subgenres
subgenus1145753subgenus
subgoals1145553subgoals
subjoined1944233subjoined
subjoins1745453subjoins
sublates10315003sublates
sublimes12310033sublimes
subline9316893subline_
sublots92410913sublo_ts
submenus1245903submenus
subnet82520933sub__net
subnets92512083sub__nets
suborned1137303suborned
suborner1047383suborner
suborners1146313suborners
suborns939493sub_orns
subpanel1246073subpanel
subpanels1344393subpanels
subpenas1246903subpenas
subpoena1244703subpoena
subpoenas1344413subpoenas
subraces12313033subraces
subrents10310293subrents
subrings11229883subrings
subrules1039723subrules
subsales10310123subsales
subsense1046963subsense
subsenses1147473subsenses
subseres10312423subseres
subsides11410823subsides
subsites10312783subsites
subsoils1076653subsoils
subsonic1245753subsonic
subsumes1246923subsumes
subteens1037423subteens
subtends1136173subtends
subtonic1246923subtonic
subtonics1345433subtonics
subtypes1544553subtypes
subvene1238493subvene_
subvened1436423subvened
sucroses1039933sucroses
sulfone1037483sulfone_
sulphones1446063sulphones
summoned1345723summoned
summoner1245533summoner
summoners1344733summoners
summons1158003summon_s
summonses1344543summonses
sunstones947883sunstones
supines94216383su_pines
supposes1238203supposes
syboes1139343syb_o_es
umbones1138013_umbones
unzoned172310653_unzoned
zones145528043___zones

Search took 7 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.406440125.6
2DLD Change Limit146162986.31023163.5
3Display Results98980.0501960.0
 (SQL Overall)178691986.76626410.1
 
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.