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

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

126 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
creatures113841(None) 
creature1038721creature_
crenatures1245331crenatures
arcatures1186832arcatures
armatures1166972armatures
cofeatures1544002cofeatures
creates95225192creat__es
creatines112814432creatines
creatives14279692creatives
creators102814402creator_s
creatural1144902creatural
creaturely1552602creaturely
crenature1145752crenature_
cubatures1344432cubatures
curvatures1542772curvatures
features11310332_features
prelatures1245722prelatures
prematures1447052prematures
renatures939442_renatures
treasures946632treasures
apertures1146473apertures
arcature1086483arcature_
armature10106963armature_
armatured1264613armatured
breathers14319103breathers
breathes134212903breat_hes
caestuses1144893caestuses
calentures1244603calentures
captures1239443c_aptures
caricatures1564003caricatures
ceintures1136733ceintures
censures102211623c_ensures
centares102913893c_entares
centres93817123c_ent_res
centuries11311333c_enturies
cerates95428253cerat__es
cestuses1038083c_estuses
cheaters133613513cheater_s
cinctures1346063cinctures
clotures10299023c_lotures
coendures1245213coendures
coenures1048683coe_nures
cofeature1444153cofeature_
cofeatured1642713cofeatured
coutures10311993c_outures
covertures1545463covertures
cratches153012543cr_atches
cratered1149683cr_atered
craters95021893cr_ater_s
crates85736063cr_at__es
creameries1446673creameries
creamers124111303creamer_s
creamwares1742453creamwares
creasers103612823creaser_s
creases94020963crea__ses
create85126373creat__e_
created104323443creat__ed
creatine103417413creatine_
creatins103617513creat_ins
creations112614543creations
creative132812803creative_
creator93714433creator__
cremates124216003cremat__es
crematories1546853crematories
cremators1369803cremator_s
critturs10374593crittur_s
cubature1244693cubature_
cultures10310153c_ultures
curvature1442793curvature_
defeatures1444003defeatures
denatures1038123denatures
dentures9312453_dentures
erasures837203er_asures
feature1039853_feature_
featured1237683_featured
filatures1245853filatures
fractures14147233fractures
gestures9310013_gestures
gravures1234903gr_avures
immatures1344323immatures
lectures101310153_lectures
ligatures1044933ligatures
matures9314303__matures
measures1038913_measures
meatuses1038203_meatuses
natures7311963__natures
nervatures1363523nervatures
ossatures943423ossatures
overtures121611453overtures
pleasures1145573pleasures
preassures1245273preassures
preattunes1243973preattunes
precures12312903pre_cures
prelature1146263prelature_
premature1347783premature_
pressures1149063pressures
prestores114716083prestores
raptures1037573_raptures
rasures7312013_r_asures
reassures937223_reassures
recaptures1474463_recaptures
renature839323_renature_
renatured1047283_renatured
restores85222993_restores
retires74726213_re_tires
retunes76918403_re_tunes
returns79712593_re_turns
ruptures1056683_ruptures
scriptures1443793scriptures
serratures1044853serratures
statures83711113_statures
textures1597523_textures
theatres11298633theat_res
treasure846753treasure_
treasured1044983treasured
treasurer944253treasurer
treasurers1043203treasurers
treasuries1045533treasuries
treaters83615843treater_s
treaties8316983treat_ies
treatises9310373treatises
tressures946293tressures
ventures11311493_ventures
vestures11311043_vestures
wreathers15257493wreathers
wreathes14299893wreat_hes

Search took 9 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.1561145455.1
2DLD Change Limit1486411267.98318619.7
3Display Results1261260.0462739.1
 (SQL Overall)1786911268.18521831.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.