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

198 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
creatines11281443(None) 
creatine103417411creatine_
creatins103617511creatin_s
creatives14279691creatives
ceratins102818732ceratin_s
creakiness1645962creakiness
creaminess1446202creaminess
creates95225202creat__es
creatin93618132creatin__
creating113921952creatin_g
creatinines1344042creatinines
creations112614542creations
creative132812802creative_
creatures1138422creatures
crestings12298042crestings
cretins93216422cre_tin_s
ratines75328582_r_atines
retines75134672_re_tines
treaties8316982treati_es
treatises9310372treatises
argentines1146943argentines
astatines9310343astatines
beatings114113233_beatings
betaines10313293_betaines
breadlines1345733breadlines
breakings16297063breakings
breathes134212903breat_hes
breathiness1644323breathiness
breathings16234313breathings
calamines13312223calamines
canines93724033c__anines
carabines13311473carabines
carnitines1277813carnitines
caryatides1644493caryatides
cavatinas1444783cavatinas
cavatine13310323cavatine_
celestines12136893celestines
centiles103615813c_entiles
centimes124012613c_entimes
centones10313663c_entones
ceramides1447453ceramides
cerates95428253cerat__es
ceratin93020163ceratin__
certainer1146193certainer
certainest1248863certainest
cetanes9315133c_e_tanes
chaines124518733c_ha_ines
cheapies1539033cheapi_es
cheating144014523cheatin_g
clearings12286063clearings
cleating113518143cleatin_g
clematises1445733clematises
coatings113811843c_oatings
cobaltines14114473cobaltines
cocaines121314443coca_ines
craftiness1545753craftiness
cranes84330753cr_a__nes
crannies10313013cr_annies
cratches153012543cr_atches
crates85736063cr_at__es
crating103725203cr_atin_g
cratons94316033cr_aton_s
cravings14428223cr_avings
crazies183413853cr_azi_es
craziness2037383cr_aziness
creakier14328333creaki_er
creakiest15238593creaki_est
creaking153414123creakin_g
creamier12319063creami_er
creamiest13248933creami_est
creaming133413143creamin_g
creases94020963crea__ses
creasier103210193creasi_er
creasiest11229943creasi_est
creasing113314443creasin_g
create85126383creat__e_
created104323453creat__ed
creatinine1245073creatinine
creation102816513creati_on
creationism1576463creationism
creationist1379233creationist
creatively1846673creatively
creativeness1747763creativeness
creators102814413creat_ors
creature1038743creature_
creepies1239613creepi_es
creepiness1444883creepiness
cremains1238693cremain_s
cremates124216003cremat__es
cremating14312203crematin_g
cremations14410713cremations
creminis12208253cre_minis
crenations12511693crenations
crenatures1245343crenatures
creolises1157893creolises
creolizes2056583creolizes
cresting114017043crestin_g
cretics112911653cre_ti_cs
cretin82917913cre_tin__
cretinism1347123cre_tinism
cretinous1145893cre_tinous
cretonnes1144723cretonnes
crevices1536713cre_vices
croceines1347733croceines
cruelties1144893cruelti_es
crustiness1237293crustiness
curarines11710553curarines
curatives1437823curatives
cyanines132710543c_yanines
cystines1339473c_ystines
dentines93418403_dentines
destines93619663_destines
dreaminess1345313dreaminess
dreamtimes1542193dreamtimes
drearies92313413dreari_es
dreariness1146283dreariness
eatings84616443__eatings
emetines10611053eme_tines
ergatives1346443ergatives
freakiness1745183freakiness
gelatines102910543gelatines
gradines103615253gr_adines
gratine84719193gr_atine_
gratinee93710783gr_atinee
gratinees10307323gr_atinees
gratings103910763gr_atings
gratins84119183gr_atin_s
greasiness1156543greasiness
greatened1144583greatened
greatens9307593greaten_s
greatness1036903great_ness
greetings11276043greetings
gregarines1244783gregarines
grenadines1245173grenadines
hematines141312203hematines
isatines8310663_isatines
keratins122313483keratin_s
meatiness11311183_meatiness
palatines11313043palatines
patines95225763__patines
pectines121914683_pectines
pralines102217723pr_alines
preattunes1243973preattunes
prentices131111903prentices
prestiges12310593prestiges
pretties10615133pretti_es
prettiness1257393prettiness
rapines95120863_r_apines
ratine65131823_r_atine_
ratings84217413_r_atings
ratites74920683_r_atites
ratlines83815293_r_atlines
ravines104220233_r_avines
readies83324713_readi_es
readiness102611853_readiness
readings103512643_readings
reagins84215643_reagin_s
realises82420183_realises
realizes173116843_realizes
realties8514853_realti_es
reclines103718543_reclines
redlines93916083_redlines
refines105426343_re_fines
relatives1239963_relatives
relines75331323_re_lines
repines94927383_re_pines
reptiles103913063_reptiles
reshines112615443_reshines
retained93016093_retained
retainer82913813_retainer
retainers92510763_retainers
retains74522253_retain_s
retenes76324623_re_tenes
reties65436193_re_ti_es
retiles74426993_re_tiles
retimes95020173_re_times
retinas74819353_re_tinas
retine66237333_re_tine_
retints74717013_re_tints
retinues85113153_re_tinues
retires74726213_re_tires
retunes76918403_re_tunes
rexines144719153_re_xines
routines82214363_routines
seatings93614303_seatings
serotines9312073serotines
sestines82717243_sestines
stearines9311283stearines
steatites939843steatites
sweatiness1336463sweatiness
teatimes1039443_teatimes
treating92519613treatin_g
treatise8311103treatise_
trephines1448483trephines
triazines1847543triazines
veratrines1347263veratrines
wreathes14299893wreat_hes
zeatins16311733_zeatin_s

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411986.62322443.2
3Display Results1981980.0802475.0
 (SQL Overall)1786911987.15624970.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.