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

81 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
blazers18481168(None) 
bladers104214681bladers
blamers115314211blamers
blazer174414021blazer_
blazes174817351blaze_s
brazers184513941brazers
glazers174410031glazers
bakers125323452b_akers
balers85626932b_alers
balkers134915722balkers
ballers94421012ballers
bazars174613112b_azars
beaders104120182beaders
beakers134216872beakers
bearers94619592bearers
beaters94925032beaters
beavers124417322beavers
beezers18349242beezers
belayers13298142belayers
bilayers13296912bilayers
blabbers11308152blabbers
bladders12397802bladders
blader93618582blader_
blades95221252blade_s
blamer104417142blamer_
blames105121862blame_s
blares85021632blare_s
blasters104116142blasters
blathers134713792blathers
blatters104414092blatters
blaze165520832blaze__
blazed184314712blaze_d
blazered2035062blazered
blazoners2043862blazoners
blazons1836162blazons
bleaters103412312bleaters
blitzers19417152blitzers
bloaters103311012bloaters
blowers124313592blowers
boaters93419232boaters
boozers183912442boozers
bracers114616702bracers
bravers124715522bravers
brayers124511902brayers
brazens18418712brazens
brazer174917532brazer_
brazes175522192braze_s
braziers19397192braziers
buzzers17347172buzzers
clavers124314892clavers
clawers123910962clawers
elaters74420182elaters
emblazers2243702emblazers
flakers143613272flakers
flamers124616362flamers
flayers133912032flayers
gazers164516292_gazers
glazer164212262glazer_
glazes165315642glaze_s
glaziers18406562glaziers
grazers175112442grazers
hazers184615952_hazers
lacers85225252_lacers
laders74927762_laders
lagers74826142_lagers
lakers105225152_lakers
lasers64925702_lasers
lavers94526362_lavers
layers93921182_layers
lazars153812392_lazars
lazes145129572_laze_s
mazers173917092_mazers
placers114515262placers
planers94517942planers
platers93924082platers
players124313762players
razers154919612_razers
slakers114115752slakers
slaters73123722slaters
slavers103716502slavers
slayers104513322slayers

Search took 6 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.1401276364.3
2DLD Change Limit107671814.45624163.2
3Display Results81810.090900.0
 (SQL Overall)178691814.68638132.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.