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

113 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
zooglea173337(None) 
zoogleae1842781zoogleae
zoogleal1842291zoogleal
zoogleas1843371zoogleas
zoogloea1842281zoogloea
zoogloeae1951822zoogloeae
zoogloeal1951572zoogloeal
zoogloeas1941992zoogloeas
boggle104511943boggle_
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
bogle85821683_bogle_
bogles95020833_bogles
boodle93215033boodle_
boodled113410933boodled
boodler103312003boodler
boodles103416043boodles
booger94816553boog_er
boogey124711523boog_ey
boogie93515993boogie_
boogied11379283boogied
boogies103719013boogies
booklet132312643booklet
boomlet112412273boomlet
bootleg10276633bootleg
cochlea1435343cochlea
cooled95224593coo_led
cooler84824713coo_ler
dogleg936323_dogleg
dongle83612493dongle_
dongles93212873dongles
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doo_lee
fooled104317823foo_led
footle93914383footle_
footled113610763footled
footler104011873footler
footles103715713footles
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
froglet11310063froglet
goggle94511573goggle_
goggled11348953goggled
goggler10379323goggler
goggles103510793goggles
goglet84618583_goglet
googlies1086763googlies
googly11417883googl_y
hooklet142510813hooklet
hoopla1147633hoopl_a
joggle154010353joggle_
joggled17398433joggled
joggler16398833joggler
joggles164410413joggles
longleaf1243663longleaf
mesoglea1142993mesoglea
moola75117033moo_l_a
mooley11311633moo_ley
moonlet92413273moonlet
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
noogie73612313noogie_
noogies82814583noogies
ogle56325053__ogle_
ogled75915963__ogled
ogler65917443__ogler
ogles65223183__ogles
olea46532723__o_lea
oodles73517183_oodles
poodle93112043poodle_
poodles103013513poodles
pooled94619813poo_led
pooler83819843poo_ler
rootle63214453rootle_
rootled83410533rootled
rootles73215633rootles
rootlet73015733rootlet
toggle83810873toggle_
toggled10428653toggled
toggler9399193toggler
toggles93710973toggles
tooled74918903too_led
tooler63818613too_ler
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
wooled103715503woo_led
woolen93111373woo_len
wooler93615873woo_ler
woolled1136643woolled
woollen1034723woollen
zoea137118423z_o__ea
zonula1537223zonul_a
zonulae1645963zonulae
zonule1577483zonule_
zonules1647793zonules
zooecia1843843zooecia
zooey173914803zoo__ey
zoogeny2044363zoogeny
zoogloeic2152143zoogloeic
zooier153411233zoo_ier
zoomed183610363zoo_med
zooned164011083zoo_ned
zootier163611173zootier
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 Limit1340271135.61023890.7
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.06229477.2
 
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.