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

86 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
zoogleas184337(None) 
zooglea1733371zooglea_
zoogleae1842781zoogleae
zoogleal1842291zoogleal
zoogloeas1941991zoogloeas
zoogloea1842282zoogloea_
zoogloeae1951822zoogloeae
zoogloeal1951572zoogloeal
bogglers12347603bogglers
boggles113411823boggle_s
bogles95020833_bogle_s
boodlers113710743boodlers
boodles103416043boodle_s
boogers104514633boog_ers
boogeys13476873boog_eys
boogies103719013boogie_s
booklets14247123booklets
boomlets12246673boomlets
boonless10328353boonless
bootlegs11325873bootlegs
bootless103410983bootless
cochleas1545263cochleas
cookless14258633cookless
coolers93522493coo_lers
doglegs1034783_doglegs
dongles93212873dongle_s
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613doo_lees
doorless936713doorless
fogless1138193_fogless
foodless12338383foodless
footlers113910793footlers
footles103715713footle_s
footless113710803footless
foozlers20346073foozlers
foozles19329543foozle_s
froglets1235263froglets
gogglers11276713gogglers
goggles103510793goggle_s
goglets9379783_goglets
googlies1086763googlies
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hooklets15217203hooklets
hooplas1239193hoopl_as
hoopless13279253hoopless
jogglers17356883jogglers
joggles164410413joggle_s
longleaf1243663longleaf
mesogleas1242803mesogleas
moolas83615593moo_l_as
mooleys1236863moo_leys
moonless10278043moonless
moonlets10247473moonlets
noodles83513193noodle_s
noogies82814583noogie_s
oglers74313183__oglers
ogles65223183__ogle_s
oodles73517183_oodle_s
poodles103013513poodle_s
poolers94217423poo_lers
roofless11316733roofless
rootles73215633rootle_s
rootless83910443rootless
rootlets8308653rootlets
smogless1134053smogless
songless9218823songless
togglers10276953togglers
toggles93710973toggle_s
toolers74416503too_lers
toolless836343toolless
tootlers8289503tootlers
tootles72915603tootle_s
woodless12278453woodless
woolens10398843woo_lens
woolers104214023woo_lers
woollens1144093woollens
zoeas145815613z_o__eas
zoneless1737823zoneless
zonulas1637023zonul_as
zonules1647793zonule_s
zoogeny2044363zoog_eny
zoogloeic2152143zoogloeic
zorillas1745483zorillas

Search took 8 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.1701051123.5
2DLD Change Limit146162867.23620199.3
3Display Results86860.0302866.7
 (SQL Overall)178691867.43624030.5
 
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.