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

53 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
flatware144489(None) 
flatwares1544771flatwares
bloatware1442172bloatware
clayware1643932clayware
flatcar1274612flatcar_
flatcars1344622flatcars
flatmate1346392flatmate
flatwash1742422flatwash
flatways1744322flatways
flatwise1443972flatwise
flatwork1845392flatwork
flatworm1645182flatworm
agateware1352243agateware
aware86420023__a_ware
barware12610703_barware
bloatwares1552193bloatwares
claywares1743463claywares
delftware1651483delftware
fanfare1336673f_anfare
fatwa1168063f_atwa__
fatwas1249053f_atwa_s
feature1039853feat_ure
filature1145433filat_ure
firmware1643963firmware
flancard1443373flancard
flare84823633fl___are
flatcap1463653flatca_p
flatcaps1563403flatcaps
flatland1264963flatland
flatline11298923flatline
flatmates1446193flatmates
flatter103815963flatter_
flattered13188633flattered
flatterer12187683flatterer
flatters113814203flatters
flattery14338293flattery
flatwashes1941953flatwashes
flatworks1944703flatworks
flatworms1743963flatworms
flawier13378733fla_wier
floatage1244403float_age
flotage1136683flot_age
flowage1435723fl_owage
freeware1446173freeware
giftware1542463giftware
glassware1343223glassware
platane93112303plat_ane
seaware1049633sea_ware
slipware1344543slipware
software1464253software
teaware1048143tea_ware
unaware1038033una_ware
wetware1335793_wetware

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.406440125.6
2DLD Change Limit146162536.92321112.5
3Display Results53530.0163312.5
 (SQL Overall)178691537.34524328.3
 
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.