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

55 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
rosewater1245021rosewater
roseate7613452rose_ate_
rosettes8310342rose_ttes
arsenates979373arsenates
caseates10313713case_ates
casemates1349523casemates
conepates13912283conepates
copemates1549483copemates
corelates11314863corelates
foredates13310053foredates
housemates1546133housemates
housewares1645413housewares
moderates12710753moderates
oleates7417833_ole_ates
operates10515413_operates
postdates1248863postdates
prosecutes1445663prosecutes
proselytes1544743proselytes
prostates11314423pros_tates
prostrates12411993prostrates
racemates1348853racemates
rebates95123183r__ebates
redates83423873r__edates
regelates10311113regelates
relates73731433r__elates
relegates10310943relegates
remates93827113r__emates
reoperates1249663reoperates
reseated93220263rese_ated
reseats74319583rese_at_s
resinates9314763resinates
reslates83619503res_lates
resonates9412403resonates
restates83423433res_tates
rewakes144614983r__ewakes
rewaxes173911333r__ewaxes
roommates1344843roommates
ropewalks1842423ropewalks
ropeways1644053ropewa_ys
roseately1244313rose_ately
rosebays13114903roseba_ys
roselles8310713rose_lles
rosemaries1246033rosemaries
roseries8317313rose_ries
rosets65819953rose__t_s
rosette7310373rose_tte_
rosewoods1345063rosewoods
rostrate8313843rostrate_
rosulate8310903rosulate_
rotates72819773ro__tates
sedates83418043__sedates
senates73322613__senates
sewages1139753__sewages
tolerates9312123tolerates
yokemates1844193yokemates

Search took 10 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 Filter1786911486410.843211970.3
2DLD Change Limit148641558.53317419.5
3Display Results55550.0301833.3
 (SQL Overall)178691559.40618997.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.