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

95 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
flaneries124956(None) 
flanerie1146911flanerie_
beaneries11310902beaneries
deaneries10310832deaneries
faeries104118992f_a_eries
fakeries1559832f_akeries
ferneries1239042ferneries
fineries112416742f_ineries
flackeries1955422flackeries
flatteries1347412flatteries
slaveries1249682slaveries
aeries64737783__a_eries
anergies9310453__anergies
aperies9423203__aperies
bakeries14312193_bakeries
braveries1439103braveries
canaries10318943_canaries
canneries11313083canneries
chanceries1747653chanceries
chantries14310293chantries
claries93422203cla__ries
clowneries1544743clowneries
draperies1249193draperies
eateries8324313_eateries
elaterids1046163elaterids
elaterins9410033elaterins
elaterites1048273elaterites
faerie93514683f_a_erie_
fairies103516043f_a_iries
fallaleries1453113fallaleries
fancies124018783f_an_cies
fannies103415643f_an_nies
felonries1246203felon_ries
fisheries1548643fisheries
flakers143613273flaker__s
flamers124616363flamer__s
flanes94522423flan___es
flaneurs1133953flane_urs
flangers123311373flanger__s
flanges113413273flan__ges
flankers15349303flanker__s
flaperons14125043flaperons
flares94521703fla__r_es
flatnesses1337763flatnesses
flayers133912033flayer__s
flowerier1544273flowerier
floweriest1644533floweriest
fluencies1445933fluencies
fluerics1345393fl_uerics
flummeries1743763flummeries
flunkies1536393flun_kies
flurries11188913fl_urries
fooleries1248743fooleries
fopperies1666013fopperies
forgeries13310003forgeries
foundries1345693foundries
franserias1344253franserias
fulleries1248723fulleries
galleries10311703galleries
gantries91413783_gantries
glazieries2043573glazieries
granaries10159883granaries
graperies1239613graperies
gunneries1047043gunneries
henneries1248643henneries
imageries1246783imageries
japeries17311463_japeries
joineries1648103joineries
knaveries1645013knaveries
laniaries9411213_laniaries
laterites9715053_laterites
laterizes18513013_laterizes
laundries1045563_laundries
lingeries10511813_lingeries
liveries11314373_liveries
naperies10313903_naperies
nunneries947113nunneries
orangeries11116943orangeries
panfries13149203_panfries
pantries101817393_pantries
pineries102419083_pineries
planarias1147403planarias
planers94517943planer__s
planesides1354373planesides
planetaries1345943planetaries
plenaries11410383plenaries
sceneries1149393sceneries
sealeries9313133sealeries
swanneries1344363swanneries
tanneries9310423tanneries
traceries11312863traceries
turneries948493turneries
veneries112815033_veneries
vineries112716043_vineries
wineries112316533_wineries

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 Filter1786911486410.423422437.4
2DLD Change Limit148641957.08020994.5
3Display Results95950.0462065.2
 (SQL Overall)178691957.54923670.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.