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

49 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
cutwaters144361(None) 
cutwater1344831cutwater_
cutters94218962cut__ters
anteaters939343anteaters
bathwaters1843533bathwaters
butters94521723but__ters
castraters1246473castraters
caters85336503c___aters
catheters1437013catheters
catnapers1364763catnapers
cheaters133613513c_heaters
citators10310253cit_ators
citrates102315093citrate_s
clutters103210353clut__ters
coaters93525793c__oaters
combaters1538113combaters
cottagers12305383cottagers
cotters94323443cot__ters
craters95021893c__raters
curates95323833cu_rate_s
curators10311723cu_rators
cutlases1038033cutlase_s
cutlers94217003cut__lers
cutovers1335123cut_overs
cuttages11297223cuttage_s
cutter84521003cut__ter_
cytasters1483663cytasters
dewaters122910723_dewaters
eyewaters1543603eyewaters
gutters83715513gut__ters
meltwaters1542963meltwaters
mutates92215793mut_ate_s
mutters94117143mut__ters
nutates73214973nut_ate_s
nutters74215433nut__ters
outcapers1344383outcapers
outdates93114743outdate_s
outmasters1245733outmasters
outrates82421373outrate_s
outwars10912793outwa__rs
outwastes12127693outwaste_s
putters94219193put__ters
scutters103311023scut__ters
seawaters1235713seawaters
staters73922343_st_aters
taters64932203__t_aters
updaters11255183_updaters
utters63817123_ut__ters
waters95030633___waters

Search took 7 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.406440125.6
2DLD Change Limit148641496.37623312.6
3Display Results49490.0301633.3
 (SQL Overall)178691496.81226231.8
 
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.