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

91 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
fooleries124874(None) 
booteries11312772booteries
cookeries151210632cookeries
cooperies131113312cooperies
fopperies1666012fopperies
forgeries13310002forgeries
fulleries1248722fulleries
rookeries13138172rookeries
voleries11313232_voleries
bloomeries1446103bloomeries
bobberies12107893bobberies
boiseries11411043boiseries
boweries13312293_boweries
butleries11710073butleries
cajoleries1944763cajoleries
celeries10316313_celeries
collieries1248333collieries
congeries12316403congeries
coolers93522493cooler__s
coolies93824963cool__ies
coteries10422703_coteries
crookeries1646133crookeries
cutleries1179213cutleries
cycleries1647033cycleries
dodgeries1246593dodgeries
doggeries1246673doggeries
dolerites101410893_dolerites
doolees83711613doole__es
doolies83920713dool__ies
doweries12411933_doweries
drolleries1145443drolleries
faeries104118993f__aeries
fakeries1559833f_akeries
felonries1246203felonries
feodaries1346373feodaries
ferneries1239043ferneries
fineries112416743f_ineries
fisheries1548643fisheries
flaneries1249563flaneries
flowerier1544273flowerier
floweriest1644533floweriest
folkies143612253f_ol_kies
follies103618943f_ol_lies
foodies113416753foo__dies
foolery1336693fooler__y
footers104618333footer__s
footies103721543foo__ties
footlers113910793footler__s
footsies1139643foo_tsies
foozlers20346073foozler__s
foundries1345693foundries
fowlers133411203fowler__s
galleries10311703galleries
groceries1249503groceries
helleries122611683helleries
hosieries1249213hosieries
jobberies20115423jobberies
joineries1648103joineries
lotteries9311073lotteries
mockeries17128263mockeries
monkeries15129913monkeries
moperies12313873_moperies
oogenies9311583_oogenies
oologies9312993_oologies
orreries8310123_orreries
pedleries1298783pedleries
poolers94217423pooler__s
poperies12316793_poperies
potteries11313593potteries
poultries1148453poultries
rifleries1247683rifleries
robberies13107393robberies
rockeries15128973rockeries
rogueries1047003rogueries
roperies10315763_roperies
roseries8317313_roseries
sealeries9313133sealeries
sorceries1149933sorceries
spooferies1543703spooferies
spookeries1654293spookeries
toggeries1146213toggeries
toiletries1046613toiletries
tomfooleries1771363tomfooleries
toolers74416503tooler__s
woolers104214023wooler__s
woolies104117363wool__ies
woollies1147413wool_lies
zoogenies1946833zoogenies
zoolatries1943673zoolatries
zoologies1939013zoologies
zoometries2147073zoometries

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 Filter1786911486410.420425454.8
2DLD Change Limit148641916.45623023.7
3Display Results91910.0461978.3
 (SQL Overall)178691916.92225814.9
 
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.