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

96 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
sawflies144474(None) 
barflies1338302barflies
dayflies1534462dayflies
gadflies1334732gadflies
mayflies1644912mayflies
sallies73227812sa_llies
sandflies1346512sandflies
shadflies1643832shadflies
allies63827673_a_llies
applies11311223_applies
baffies153612943ba_ffies
baffles153710683baffl_es
bailies94120203ba_ilies
ballies93725743ba_llies
bawdies134613393baw_dies
bawdries14136843bawdries
bawties124214313baw_ties
blowflies1742893blowflies
botflies1336733botflies
dailies84219263da_ilies
dallies84023193da_llies
dawdles12379163dawdl_es
dawties113312703daw_ties
families1339443families
flies85630713___flies
gallflies1344223gallflies
gallies84122713ga_llies
gawkies15429123gaw_kies
glowflies1642893glowflies
halflives1842783halflives
hawkies173311243haw_kies
jawlines18126363jaw_lines
medflies1435553medflies
outflies11310153outflies
panfries13149203panfries
raffles133611843raffl_es
rallies73823343ra_llies
ramilies10311833ramilies
reflies104418533_reflies
sables85026693sa_bl_es
saddles95415743saddl_es
safes85226723sa_f__es
safeties1139163safeties
salaries8319593salaries
sales56055593sa__l_es
salifies11314793salifies
salines74029413sa__lines
sallied83316953sa_llied
sallier73320423sa_llier
salliers83613343sa_lliers
salties73725773sa_lties
salves94221763sa__lves
samples112815453sampl_es
sanies63031953sa__nies
sanities81219773sanities
sassies74719263sa_ssies
sauries72821623sa_uries
savories11311273savories
savvies1337603sa_vvies
sawbills1344763sawbills
sawbones13126643sawbones
sawfish1637683sawf_ish
sawfishes1845743sawfishes
sawfly1535133sawfl__y
sawlike14138443saw_like
sawlogs1135393saw_logs
sawmills1343693sawmills
saxonies1537913saxonies
shooflies1544143shooflies
sicklies14710013sicklies
sillies73425083s_illies
snaffles14246043snaffl_es
softies103414613s_ofties
spiffies16277993spiffies
steelies8312553steelies
stiffies14258383stiffies
stifles103013393stifl_es
stoolies8311083stoolies
subfiles131710723subfiles
sullies74122233s_ullies
supplies1268843supplies
swabbies15115713swabbies
swaggies13136693swaggies
swales93920763s_wal_es
swamies123712063s_wamies
taffies133012693ta_ffies
tallies73624603ta_llies
tawdries12136083tawdries
tawnies102812503taw_nies
tawpies12309873taw_pies
waffies163611443wa_ffies
waffles16329983waffl_es
wafflier1733953wafflier
waffliest1844233waffliest
walies95324523__walies
wallies103320743wa_llies

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.406440125.6
2DLD Change Limit146162967.45319611.2
3Display Results96960.0462087.0
 (SQL Overall)178691967.90522604.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.