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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
flamers12461636(None) 
blamers115314211blamers
flakers143613271flakers
flamens124611061flamens
flamer114919121flamer_
flames114723691flame_s
flayers133912031flayers
foamers123812101foamers
framers125113821framers
bladers104214682bladers
blamer104417142blamer_
blames105121862blame_s
blazers184811682blazers
claimers12298742claimers
clambers144211292clambers
clammers143510692clammers
clamors11710092clamors
clampers143211892clampers
clavers124314902clavers
clawers123910972clawers
elaters74420192elaters
facers115519442f_acers
faders105117462f_aders
fakers134219532f_akers
fallers103917992fallers
falters103916472falters
fames105735922f_ame_s
farers95924052f_arers
farmers124315262farmers
fearers104815272fearers
filmers124211292filmers
firmers124711442firmers
flaggers13328072flaggers
flairs95711912fla_irs
flaker134916172flaker_
flakes134118872flake_s
flambes14419502flambes
flame105124442flame__
flamed124618972flame_d
flamen115215992flame_n
flamier123112142flamier_
flams105125012flam__s
flanes94522422flane_s
flaneurs1133952flaneurs
flangers123311372flangers
flankers15349302flankers
flappers15388382flappers
flares94521702flare_s
flashers143912652flashers
flatters113814202flatters
flavors1337292flavors
flaxes165015352flaxe_s
flayer124713562flayer_
fleers96015792fl_eers
fliers94417192fl_iers
floaters112711512floaters
flowers133413172flowers
flumes115119732flume_s
fluters103713682fluters
flyers125712802fl_yers
foamer114714312foamer_
formers128217952formers
framer114817442framer_
frames115119862frame_s
fraters103517212fraters
fumers113613382f_umers
gamers94420832_gamers
glamors1068112glamors
glazers174410042glazers
gleamers11306562gleamers
inflamers1455212inflamers
lacers85225252_lacers
laders74927762_laders
lagers74826142_lagers
lakers105225152_lakers
lambers113817112_lambers
lameds94812032_lameds
lamer75233702_lamer_
lames75445542_lame_s
lampers113817332_lampers
lasers64925702_lasers
lavers94526362_lavers
layers93921182_layers
namers84517332_namers
palmers113513622palmers
placers114515262placers
planers94517942planers
platers93924092platers
players124313762players
reamers94221082reamers
roamers93713462roamers
seamers94719432seamers
slakers114115752slakers
slammers123511222slammers
slaters73123732slaters
slavers103716502slavers
slayers104513322slayers
tamers84224032_tamers

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671983.34332207.9
3Display Results98980.0332969.7
 (SQL Overall)178691983.74947663.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.