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

66 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
freeware144617(None) 
freewares1545941freewares
freebase1344852freebase
freeway1635602freewa_y
freeways1744722freeways
redware1139362_redware
treenware1243772treenware
bakeware1745483bakeware
beware11313713__beware
brewage1347183br_ewage
caneware1347803caneware
creamware1642533creamware
creepage1344343creepage
firmware1643963firmware
flatware1444883flatware
foreswore15117403foreswore
forewarn14117173forewarn
freebased1543463freebased
freebaser1443683freebaser
freebases1444933freebases
freebee1238043free_bee
freebie1236043free_bie
freeboard1545253freeboard
freeborn1344803freeborn
freeform1644703freeform
freehand1574993freehand
freelance1445143freelance
freeman1237343freema_n
freer86021243free__r_
freers94717303free__rs
freewheel1852363freewheel
freewill1443413freewill
freewrite1543603freewrite
freewrote1552863freewrote
freezable2345093freezable
freeze18349513free__ze
freezer19348523freezer_
freezers20307173freezers
frere85617723fr_e__re
fretwork1845693fretwork
froward1436673fr_oward
ironware1144653ironware
leeward1135783_leeward
ovenware1444243ovenware
prepare111913623pr_epare
prewar114712583pr_ewar_
prewarm14479613pr_ewarm
prewarn124410153pr_ewarn
prewire124311143pr_ewire
reawake14457893_reawake
redwares1239053_redwares
reearn6612143_ree_arn
rereward1246143_rereward
rewake135218463_r_ewake
reward106017643_r_eward
rewarm115913493_r_ewarm
rewear93012003_rewear_
rewears102911043_rewears
reweave1336773_reweave
rewire95421413_r_ewire
rewore938030163_r_ewore
seaware1049633_seaware
stemware1344883stemware
teaware1048143_teaware
treenwares1343953treenwares
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.483369960.7
2DLD Change Limit146162667.34319904.9
3Display Results66660.0164125.0
 (SQL Overall)178691667.84222786.4
 
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.