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 “flavory” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
flavory164474(None) 
flavor1236661flavor_
flavors1337291flavors
flavoury1743061flavoury
favor114712452f_avor_
favors124211402f_avors
flavone1335522flavone
flavored1554572flavored
flavorer1454552flavorer
flavour1334632flavour
flavours1434692flavours
savory124310562_savory
slavery13407892slavery
alary86123443ala__ry
aleatory1148813aleatory
amatory1238623amatory
blazonry2242163blazonry
bravery15428133bravery
calory11312843_calory
calvary1537183calvary
cavort11316173_cavort
clamor1049453clamor_
clamors11710093clamors
clary105719613cla__ry
claver113816973claver_
clavers124314903clavers
clovery15407403clovery
dilatory12279273dilatory
elusory1083993elusory
factory15108343factory
faery116015483f_a_ery
fairy115318283f_a_iry
fakery16509263f_akery
falconry1642533falconry
favored1455983f_avored
favorer1355883f_avorer
favour12438333f_avour
favours13437093f_avours
fervor1235643fervor_
fervors1336233fervors
flabby1634573fla_bby
flackery20295243flackery
flacon1138633flaco_n
flacons1238053flacons
flaggy14415923fla_ggy
flagon1037983flago_n
flagons1137973flagons
flair86114123fla_ir_
flairs95711913fla_irs
flaker134916173flaker_
flakers143613273flakers
flakey164410513fla_key
flakily1736293flakily
flaky155715583fla__ky
flamer114919123flamer_
flamers124616363flamers
flamy135217473fla__my
flappy1654483fla_ppy
flare84823633fla__re
flashy15498173fla_shy
flatly123110213fla_tly
flattery14338293flattery
flatwork1845393flatwork
flatworm1645183flatworm
flaunty1354413flaunty
flavin1239303flav_in
flavine1338453flavine
flavins1338543flavins
flavones1435833flavones
flavonol1442213flavonol
flavorers1563983flavorers
flavorful1851713flavorful
flavoring1665113flavoring
flavorist1545453flavorist
flavorous1544253flavorous
flavoured1642973flavoured
flawy145913383fla__wy
flaxy189012293fla__xy
flay106332803fla___y
flayer124713563flayer_
flayers133912033flayers
fleawort1447023fleawort
fleury12417353fl_eury
flexor1634503flexor_
flexors1734773flexors
flooey123910173fl_ooey
floor84215233fl_oor_
floors94112353fl_oors
floosy12368153fl_oosy
floozy21356613fl_oozy
flora85317103fl__ora
floury12449573fl_oury
flowery16327783flowery
fluor84512773fl_uor_
fluors94311373fl_uors
flurry12397113fl_urry
flyboy17113913flybo_y
fumatory1644923fumatory
glairy10448273gla_iry
glamor958183glamor_
glamors1068113glamors
glary96018543gla__ry
glory96413293gl__ory
ivory1137373__ivory
klavern1433003klavern
knavery1733123knavery
labor75117313_labor_
labors84016413_labors
lavatory1445693_lavatory
laver85031793_laver_
lavers94526363_lavers
livery124910903_livery
lory75931713_l__ory
oblatory1345793oblatory
olivary1345163olivary
oratory1039403oratory
quavery22225483quavery
salvor94711093salvor_
salvors103910913salvors
savor85417943_savor_
savors95616103_savors
savoury13365873_savoury
savoy114713883_savo_y
slaver94419613slaver_
slavers103716503slavers
slavey124011803slav_ey
suasory1046043suasory
unsavory1442573unsavory
vapory14398763_vapory
wavery154610053_wavery

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271305.95322514.2
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.40527898.7
 
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.