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

77 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
flareup124317(None) 
flareups1342471flareups
faceup1334892f_aceup
flaneur1034182flaneur
flare84823632flare__
flared105317602flare_d
flares94521702flare_s
larrup835712_larrup
alarum85411983alar_um
blare75826233blare__
blared95018243blare_d
blares85021633blare_s
claret84026573clare_t
clarets94111103clarets
closeup11113433closeup
farceur12525273f_arceur
fare76354463f_are__
fared95842343f_are_d
farer86733143f_are_r
farers95924053f_arers
fares85852873f_are_s
feared106320433feare_d
fearer94820183feare_r
fearers104815273fearers
fearful1345593fearful
filaree10611213filare_e
filarees1187643filarees
flake125119973flake__
flaked144715653flake_d
flaker134916173flake_r
flakers143613273flakers
flakes134118873flake_s
flakey164410513flake_y
flame105124443flame__
flamed124618973flame_d
flamen115215993flame_n
flamens124611063flamens
flameout1347993flameout
flamer114919123flame_r
flamers124616363flamers
flames114723693flame_s
flanes94522423flane_s
flaneurs1133953flaneurs
flap96128703fla___p
flaring114116803flaring
flatcap1463653flatcap
flattop1244403flattop
flatus94310783fla_tus
flavour1334633flavour
flawed134712723flawe_d
flaxen16518573flaxe_n
flaxes165015353flaxe_s
flayed134414053flaye_d
flayer124713563flaye_r
flayers133912033flayers
floret9321123flore_t
florets1039853florets
glare65222963glare__
glared84715203glare_d
glares75518873glare_s
laree56036293_lare_e
larees65323113_larees
lares54852633_lare_s
larrups934733_larrups
larum74317973_lar_um
layup1037723_la_yup
lineup835983_lineup
makeup1434863_makeup
markup1436903_markup
pareu74928743_pareu_
pareus85420743_pareus
scaleup1134483scaleup
shakeup1632763shakeup
shapeup1443293shapeup
startup934963startup
takeup1234583_takeup
warmup1335343_warmup

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 Limit134027777.05019010.9
3Display Results77770.0135923.1
 (SQL Overall)178691777.45323975.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.