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 “creates” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
creates9522521(None) 
cerates95428251cerates
crates85736061cr_ates
creases94020961creases
create85126381create_
created104323461created
cremates124216011cremates
acreages1138382acreages
aerates74627502aerates
aretes64425362are_tes
berates94126882berates
breathes134212912breathes
breaths124411202breaths
carates95630612carates
caseates10313712caseates
cates75951892c__ates
ceases84427072c_eases
cerastes101111092cerastes
cerate84829462cerate_
cerated103922472cerated
cerites94823432cerites
certes84623082c_ertes
cetes75731102c_e_tes
cheated134416352cheated
cheater124816962cheater
cheaters133613512cheaters
cheats114519542cheat_s
chelates132713852chelates
cleated103417852cleated
cleats84919312cleat_s
cleaves124111622cleaves
cocreates132611892cocreates
comates114123642comates
corelates11314872corelates
crakes124921812cr_akes
cranes84330752cr_anes
crapes104727692cr_apes
crases85532312cr_ases
crate76537402cr_ate_
crated94827772cr_ated
crater85026642cr_ater
craters95021892cr_aters
craves115825392cr_aves
crazes174720132cr_azes
creaked143413232creaked
creaks124315962crea_ks
creamed123913712creamed
creamer113714092creamer
creamers124111312creamers
creams104715252crea_ms
crease85519572crease_
creased104315592creased
creaser94415742creaser
creasers103612842creasers
creatin93618132creatin
creatines112814432creatines
creatins103617512creatins
creatives14279692creatives
creator93714452creator
creators102814422creators
creatures1138422creatures
creches14313092creches
creeses93914622creeses
cremate113816182cremate_
cremated133412962cremated
cremes104517992cre_mes
crenate93317112crenate_
crenated113013912crenated
creoles9913322creoles
crepes105419342cre_pes
cresses94219812cresses
crested103416552crested
crests85218702crest_s
crewmates16375812crewmates
croutes94815652croutes
curates95323832curates
curettes1039312curettes
derates84028892derates
ergates8314492ergates
grates75429892gr_ates
greases84816712greases
greaten83610642greaten
greatens9307592greatens
greater84416492greater
greatest939872greatest
greats76318402great_s
greaves113311442greaves
ideates8313732ideates
ocreate93711742ocreate_
oleates7417832oleates
orates64328612or_ates
prates84633162pr_ates
predates11615822predates
prelates10418582prelates
rates55352012_r_ates
reales64934122_reales
reatas64021022_reatas
reaves94127572_reaves
rebates95123192_rebates
recreates11313372recreates
redates83423882_redates
relates73731442_relates
remates93827122_remates
rentes65431192_rentes
treated83618702treated
treater74219832treater
treaters83615852treaters
treaties8316982treaties
treats64821702treat_s
uncreates11310442uncreates
urates65027762ur_ates
ureases74416722ureases
wreathes14299892wreathes
wreaths13338382wreaths

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.766233278.1
2DLD Change Limit1076711145.00021534.2
3Display Results1141140.0303800.0
 (SQL Overall)1786911145.79630830.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.