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

108 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
flavour133463(None) 
favour12438331f_avour
flavor1236661flavo_r
flavours1434691flavours
flavoury1743061flavoury
clamour1196332clamour
favor114712452f_avo_r
favours13437092f_avours
fervour1343102fervour
flaneur1034182flaneur
flavone1335522flavone
flavorer1454552flavorer
flavors1337292flavors
flavory1644742flavory
flavoured1642972flavoured
flour84916452fl__our
glamour1065132glamour
labour84210932_labour
savour94110702_savour
amour75014853__amour
belabour1243773belabour
clamor1049453clamo_r
clamours1255993clamours
clangour11293803clangour
claver113816973clav_er
clavier1239173clavier
clavus11347353clav_us
clour76617283cl__our
devour1076703_devour
dyvour1393343_dyvour
enamour945433enamour
faitour1034883faitour
fallout10313503fallout
famous11412393f_amous
favorer1355883f_avorer
favors124211403f_avors
favoured1533963f_avoured
favourer1443823f_avourer
favus114311733f_av_us
fervor1235643fervo_r
fervours1453053fervours
flacon1138633flaco_n
flacons1238053flacons
flagger12469353flagger
flagon1037983flago_n
flagons1137973flagons
flair86114123fla__ir
flaker134916173fla_ker
flakier143910203flakier
flameout1347993flameout
flamer114919123fla_mer
flamier123112143flamier
flaneurs1133953flaneurs
flanger113412623flanger
flanker143911293flanker
flapper14359203flapper
flareup1243173flareup
flasher133914063flasher
flatcar1274613flatcar
flatter103815963flatter
flatus94310783fla_tus
flavin1239303flav_in
flavine1338453flavine
flavins1338543flavins
flavones1435833flavones
flavonol1442213flavonol
flavored1554573flavored
flavorers1563983flavorers
flavorful1851713flavorful
flavorous1544253flavorous
flavouring1743003flavouring
flawier13378733flawier
flaxier17337983flaxier
flayer124713563fla_yer
flexor1634503flexo_r
flivver1633043flivver
floor84215233fl__oor
flours94414053fl__ours
floury12449573fl__oury
flout86226203fl__out
fluor84512773fl_uo_r
flyover1633513flyover
four76226863f___our
fractur12135563fractur
fraktur14153033fraktur
fulvous1334543fulvous
giaour735363gia_our
glamor958183glamo_r
glamours1184733glamours
haviour1354823_haviour
labor75117313_labo_r
labours9349893_labours
langur7109303_langur
laveer94110423_laveer
laver85031793_lav_er
layout9513703_layout
lour45430683_l__our
paviour1244623_paviour
salvor94711093salvo_r
sapour83812373_sapour
saviour1035213_saviour
savor85417943_savo_r
savours10389343_savours
savoury13365873_savoury
slaver94419613slav_er
tabour84011323_tabour
valour93010373_valour
vapour11378873_vapour

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271086.61020276.4
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.04625360.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.