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

46 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
shooflies154414(None) 
dhoolies1246962dhoo_lies
shadflies1643832shadflies
stoolies8311082stoo_lies
blowflies1742893blowflies
botflies1336733_botflies
coolies93824963_coo_lies
dhooties1237643dhoo_ties
doolies83920713_doo_lies
ghoulies1235393gh_oulies
glowflies1642893glowflies
googlies1086763_googlies
holies94630033_h_o_lies
hollies103420813_h_ollies
homilies132710113_homilies
hoochies1639603_hoochies
hoodies113419833_hoo_dies
hoofless14258013_hoofless
hooflike1834853_hooflike
hookies144017443_hoo_kies
hoolie93217783_hoo_lie_
hourlies1138343_hourlies
roofies103014413_roof_ies
rooflines1245373_rooflines
sandflies1346513sandflies
sawflies1444743s_awflies
shoalier1137073sh_oalier
shoaliest1238503sh_oaliest
shoddies1336053sh_oddies
shoofly1634353shoofl__y
shooled115212663shoo_l_ed
shooling123012563shoo_ling
shools94919013shoo_l__s
shorelines1346143shorelines
shorties11414583sh_orties
shuffles17297783shuffl_es
smoothies1456133smoothies
snoozles17335563snoozl_es
softies103414613s__ofties
spooferies1543703spooferies
spoonies101911753spoo_nies
stoneflies1343213stoneflies
stoolie739723stoo_lie_
whoopies16267373whoo_pies
woolies104117363_woo_lies
woollies1147413_woollies

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.406440125.6
2DLD Change Limit148641466.28023668.9
3Display Results46460.0331393.9
 (SQL Overall)178691466.71926594.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.