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

103 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
flavours143469(None) 
favours13437091f_avours
flavors1337291flavo_rs
flavour1334631flavour_
flavoury1743061flavoury
clamours1255992clamours
favors124211402f_avo_rs
favour12438332f_avour_
fervours1453052fervours
flaneurs1133952flaneurs
flavones1435832flavones
flavor1236662flavo_r_
flavorers1563982flavorers
flavory1644742flavo_ry
flavoured1642972flavoured
flours94414052fl__ours
glamours1184732glamours
labours9349892_labours
savours10389342_savours
amours83512663__amours
belabours1343543belabours
clamors11710093clamo_rs
clamour1196333clamour_
clangours12263123clangours
clavers124314903clav_ers
claviers1367103claviers
clavus11347353clav_u_s
clours85215093cl__ours
devours1166643_devours
dyvours1453183_dyvours
enamours1044663enamours
faitours1134263faitours
fallouts1137883fallouts
famous11412393f_amou_s
favor114712453f_avo_r_
favorers1465493f_avorers
favoured1533963f_avoured
favourer1443823f_avourer
favourers1543123f_avourers
favus114311733f_av_u_s
fervors1336233fervo_rs
fervour1343103fervour_
flacons1238053flaco_ns
flaggers13328073flaggers
flagons1137973flago_ns
flairs95711913fla__irs
flakers143613273fla_kers
flameouts1443923flameouts
flamers124616363fla_mers
flaneur1034183flaneur_
flangers123311373flangers
flankers15349303flankers
flappers15388383flappers
flareups1342473flareups
flashers143912653flashers
flatcars1344623flatcars
flatters113814203flatters
flatus94310783fla_tu_s
flavines1437893flavines
flavins1338543flav_ins
flavone1335523flavo_ne
flavonol1442213flavonol
flavonols1542183flavonols
flavored1554573flavored
flavorer1454553flavorer
flavorist1545453flavorist
flavorous1544253flavorous
flavouring1743003flavouring
flayers133912033fla_yers
flexors1734773flexo_rs
flivvers1733113flivvers
floors94112353fl__oors
flour84916453fl__our_
floury12449573fl__oury
flouts94315273fl__outs
fluors94311373fl_uo_rs
flyovers1733673flyovers
fours85521493f___ours
fracturs13146313fracturs
frakturs15163263frakturs
fulvous1334543fulvou_s
giaours834573gia_ours
glamors1068113glamo_rs
glamour1065133glamour_
haviours1443843_haviours
labors84016413_labo_rs
labour84210933_labour_
langurs889103_langurs
laveers10329363_laveers
lavers94526363_lav_ers
layouts1046483_layouts
lours55125293_l__ours
paviours1343613_paviours
salvors103910913salvo_rs
sapours93610623_sapours
saviours1154273_saviours
savors95616103_savo_rs
savour94110703_savour_
savoury13365873_savoury
slavers103716503slav_ers
tabours94110093_tabours
valours10248743_valours
vapours12277463_vapours

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.1561145455.1
2DLD Change Limit1461621037.67019056.3
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.87222699.6
 
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.