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

70 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
zooidal174509(None) 
conoidal1149012conoidal
cotidal1038462cotidal
geoidal936712geoidal
hyoidal1444802hyoidal
ovoidal1144022ovoidal
toroidal966392toroidal
zooid15312102zooid__
zooids1637092zooid_s
zoonal1558082zoo_nal
alodial899953alodial
anodal72512123ano_dal
apodal9289833apo_dal
apsidal1046703apsidal
biocidal1344943biocidal
bridal9511453_bridal
chordal13449883chordal
choroidal1544673choroidal
coccoidal1343613coccoidal
coital84117053_coital
colloidal1244913colloidal
comical13312223comical
conical11316203conical
conidial1159503conidial
cordial10312953cordial
cuboidal1344243cuboidal
domical1239373domical
doodad936423doo_dad
ecocidal1354963ecocidal
fluidal1144653fluidal
forbidal1444833forbidal
fucoidal1443783fucoidal
gonadal956523gonadal
gonidial1065943gonidial
gooral7310463goo_ral
gyroidal1343693gyroidal
holiday1436143holiday
jovial1636543jovi_al
keloidal1344103keloidal
lipoidal1144473lipoidal
logical1038513logical
modal85919243_mo_dal
monadal1047893monadal
mucoidal1344793mucoidal
nidal65217103__nidal
nodal64717793_no_dal
nodical1049863nodical
nominal92712373nominal
nonideal947303nonideal
nontidal948673nontidal
noonday1144603noonday
ogival1035873_ogival
ovoidals1242493ovoidals
poundal1036403poundal
social8813333soci_al
somital939403somital
stoical9310283stoical
tidal64516443__tidal
topical1139953topical
toxical1637643toxical
zoarial1646923zoarial
zodiac1835303zodi_ac
zodiacal2042243zodiacal
zoeal144813783z_o_eal
zonal145116853z_o_nal
zoogleal1842293zoogleal
zooier153411233zooi_er
zooiest16199923zooiest
zoril143916693zori__l
zorilla1646023zorilla

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 Filter1786911340270.406440125.6
2DLD Change Limit134027705.78023188.1
3Display Results70700.0164375.0
 (SQL Overall)178691706.20228811.8
 
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.