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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
creases9402096(None) 
ceases84427071c_eases
crases85532311cr_ases
crease85519571crease_
creased104315581creased
creaser94415731creaser
creasers103612831creasers
creates95225201creates
creeses93914621creeses
cresses94219811cresses
greases84816711greases
ureases74416721ureases
acreages1138372acreages
arrases71214542arrases
boreases10310252boreases
breasts939702breasts
camases114216342camases
carcases12313082carcases
caresses10314062caresses
caseases10410472caseases
cases75048382c__ases
cease75227652c_ease_
ceased94920782c_eased
censes83721802c_enses
cerastes101111092cerastes
cerates95428252cerates
cereuses1049242cereuses
cerises94722252cerises
ceruses93716232ceruses
cesses84221362c_esses
chases115128232c_hases
cheeses123613102cheeses
chesses124112632chesses
cleanses10358142cleanses
cleaves124111622cleaves
crakes124921812cr_akes
cranes84330752cr_anes
crapes104727692cr_apes
crashes124618402cr_ashes
crasis85020472cr_asis
crass76328042cr_as_s
crates85736062cr_ates
craves115825392cr_aves
crazes174720132cr_azes
creaked143413232creaked
creaks124315962crea_ks
creamed123913712creamed
creamer113714092creamer
creamers124111312creamers
creams104715252crea_ms
creasier103210192creasier
creasiest11229942creasiest
creasy114612302creas_y
create85126382create_
created104323452created
creches14313092creches
creese84014332creese_
creeshes1336952creeshes
cremates124216002cremates
cremes104517992cre_mes
creoles9913322creoles
crepes105419342cre_pes
cress75022832cre_s_s
cresset93319942cresset
cressets10309102cressets
crests85218702cre_sts
crevasse1343082crevasse
crevasses1444132crevasses
crises84529432cr_ises
crosses94220792crosses
cruises93514442cruises
cruses88127712cr_uses
cycases1437532cycases
cyeses11510122cye_ses
decreases1237222decreases
dresses83716172dresses
eases56041612__eases
erases64425402er_ases
feases95422922_feases
grease75416232grease_
greased93812392greased
greaser83913082greaser
greasers93410252greasers
greaves113311442greaves
increases1157382increases
leases65428112_leases
peases85229472_peases
pleases94515482pleases
prases84429022pr_ases
presses93523152presses
rases55447212_r_ases
reales64934122_reales
reaves94127572_reaves
reuses66025522_reuses
teases65426272_teases
tresses73719542tresses
uneases73316262uneases
urases63723562ur_ases
urease64516992urease_

Search took 4 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.360496363.9
2DLD Change Limit107671993.09334811.2
3Display Results99990.0303300.0
 (SQL Overall)178691993.48351303.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.