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

139 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
creature103874(None) 
creatures1138421creatures
crenature1145761crenature
arcature1086502arcature
armature10106972armature
cofeature1444152cofeature
create85126382creat__e
creatine103417412creatine
creative132812802creative
creator93714452creator_
creators102814422creators
creatural1144912creatural
creaturely1552612creaturely
crenatures1245342crenatures
cubature1244692cubature
curvature1442792curvature
feature1039852_feature
prelature1146272prelature
premature1347792premature
renature839332_renature
treasure846752treasure
aperture1046393aperture
arcatures1186853arcatures
armatured1264623armatured
armatures1166983armatures
bravure1254393br_avure
breathe123711853breat_he
breather133610603breather
calenture1144313calenture
capture1138913c_apture
caricature1474043caricature
ceinture1036313ceinture
censure92310603c_ensure
centare93113703c_entare
centre84316643c_ent_re
century1237193c_entury
cerate84829463cerat__e
cheater124816963cheater_
cheaters133613513cheaters
cincture1245583cincture
cloture9238453c_loture
coendure1145463coendure
coenure968153coe_nure
cofeatured1642713cofeatured
cofeatures1544003cofeatures
couture9310623c_outure
coverture1445413coverture
crate76537403cr_at__e
crater85026643cr_ater_
cratered1149693cr_atered
craters95021893cr_aters
creakier14328333creakier
creamer113714093creamer_
creamers124111313creamers
creamery15385983creamery
creamier12319063creamier
creamware1642533creamware
crease85519573crea__se
creaser94415743creaser_
creasers103612843creasers
creasier103210203creasier
creatable1339563creatable
created104323463creat_ed
creates95225213creat_es
creatin93618133creat_in
creatines112814433creatines
creating113921953creating
creatins103617513creatins
creation102816513creation
creatives14279693creatives
cremate113816183cremat__e
cremator1269203cremator_
cremators1369833cremators
crematory1647223crematory
crenate93317113crenat__e
crittur9315133crittur_
critturs10374593critturs
cubatures1344433cubatures
culture939393c_ulture
curvatures1542773curvatures
defeature1344343defeature
denature938073denature
denture8311893_denture
erasure736943er_asure
featured1237683_featured
features11310333_features
filature1145433filature
fracture13147143fracture
gesture839243_gesture
gravure1134953gr_avure
greater84416493greater_
immature1244443immature
lecture9149523_lecture
ligature945133ligature
mature8313473__mature
measure939033_measure
nature6311263__nature
nervature1263823nervature
ocreate93711743ocreat__e
ossature843303ossature
overture111511683overture
pleasure1045543pleasure
preassure1145623preassure
preattune1143573preattune
precure11312553pre_cure
prelatures1245733prelatures
prematures1447063prematures
pressure1039773pressure
prestore104217353prestore
rapture937393_rapture
rasure6311423_r_asure
reassure847343_reassure
recapture1384713_recapture
renatured1047293_renatured
renatures939453_renatures
restore75822983_restore
retire64927013_re_tire
retore67630773_re_tore
retune69121953_re_tune
return623222523_re_turn
retuse66617223_re_tuse
rupture966163_rupture
scripture1343883scripture
serrature945013serrature
stature74410683_stature
texture1497083_texture
theatre10358503theat_re
treasured1044983treasured
treasurer944253treasurer
treasures946633treasures
treasury1143793treasury
treater74219833treater_
treaters83615853treaters
treatise8311113treatise
tressure846483tressure
venture10311173_venture
vesture10310373_vesture
wreathe13339053wreat_he
wreather14268603wreather

Search took 8 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621396.76621602.4
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.26524596.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.