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

197 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
creepier123625(None) 
creeper11339981creep_er
creepie1137481creepie_
creepies1239611creepies
crepier1139741cr_epier
breezier1934532breezier
cheekier1735102cheekier
cheeper143610742cheep_er
cheerier1348002cheerier
cheesier1335962cheesier
crampier14288902crampier
crappier14288132crappier
creakier14328332creakier
creamier12319062creamier
creasier103210192creasier
creeped12329712creep_ed
creepers12318632creep_ers
creepiest1337062creepiest
creepily1574952creepily
creeping133310102creeping
crimpier14287322crimpier
crispier12297252crispier
croupier1246882croupier
greedier1036082greedier
greenier938712greenier
preppier1156642preppier
reedier83815302_reedier
reefier102912552_reefier
reekier113111122_reekier
seepier92912012_seepier
sleepier1036782sleepier
sweepier1355492sweepier
weepier12319272_weepier
beefier12329093_beefier
beeper103714093_beep_er
beerier93613023_beerier
bleeper11458253bleep_er
breeder103210043bree_der
brevier1237763br_evier
campier133313273c_ampier
careener1039333caree_ner
careerer1038583caree_rer
cheaper144010583cheap_er
cheapie1437563cheapie_
cheapies1539033cheapies
cheeped153410593cheep_ed
cheepers15329013cheep_ers
cheeping16329553cheeping
cheerer123511753chee_rer
chertier1387873chertier
chestier1387423chestier
chewier1537593c_hewier
chippier17297673chippier
chirpier15276303chirpier
choppier17286643choppier
clumpier1435583clumpier
comelier12310653comelier
copier103722893c__opier
crabbier14326803crabbier
craftier1376193craftier
craggier12116063craggier
crankier14339163crankier
crapper133913193cr_apper
crappie13298983crappie_
crappies142911163crappies
crawlier13216873crawlier
crazier183610743cr_azier
creamer113714093cr_eamer
creaser94415743cr_easer
creeled104012013cree_led
creeling113513363creeling
creep95218103creep___
creepage1344343creepage
creepages1444303creepages
creepiness1444883creepiness
creeps104213623creep__s
creepy13418803creep__y
creese84014333cree_se_
creeses93914623cree_ses
creeshed1435693creeshed
creeshes1336953creeshes
crepe95520723cr_ep_e_
creped114115703cr_ep_ed
crepes105419343cr_ep_es
crepey135110933cr_ep_ey
crepiest12310383cr_epiest
creping122913653cr_eping
crier74724463cr___ier
crimper136510423crimp_er
crippler14826713crippler
crisper113511053crisp_er
croakier14436263croakier
cropper133312963cr_opper
croppie13278793croppie_
croppies143111133croppies
crosier94116573cr_osier
croupiers1334653croupiers
crozier18369933cr_ozier
cruddier1244153cruddier
crueler939023crue_ler
crueller1056453crueller
crumbier1456363crumbier
crummier1435603crummier
crumplier1543783crumplier
crupper13338563cr_upper
crustier10259533crustier
cuppier1368323c_uppier
cutesier1045623cutesier
deedier93011593_deedier
deeper93613503_deep_er
dreamier11287293dreamier
drearier9297923drearier
dreggier1193553dreggier
dressier956863dressier
drippier1385043drippier
droopier1145573droopier
dweebier1442223dweebier
eelier64216463__eelier
eerier64320023__eerier
fleecier1334763fleecier
freakier15246483freakier
freebie1236043freebie_
freebies1337873freebies
freezer19348523free_zer
frettier1156593frettier
frumpier1534173frumpier
geekier12286393_geekier
gleetier934913gleetier
grapier103712603gr_apier
greasier9298083greasier
greener83111713gree_ner
greenie8310123greenie_
greenies9312673greenies
greeter82812673gree_ter
gripier103210323gr_ipier
grippier1355203grippier
grumpier1334803grumpier
hempier14319003_hempier
keeper123811923_keep_er
leerier73111503_leerier
needier84010623_needier
ornerier846043ornerier
peeper103614803_peep_er
peppier10268323_peppier
preemie11310563preemie_
preemies12512193preemies
preener93114833pree_ner
premier113515633pr_emier
preppie1058093preppie_
preppies1149693preppies
prettier1069043prettier
rapier84019993_r_apier
raspier93110643_raspier
readier83117423_readier
reaper84223143_reap_er
reechier1336673_reechier
reefer93314363_ree_fer
reeker103715593_ree_ker
reeler63822573_ree_ler
reenter73217793_reenter
reifier103414523_reifier
relier65826183_r_elier
rentier73618223_rentier
repiner94816903_r_epiner
replier94214973_replier
respire9411543_respire
ropier84118803_r_opier
roupier9319493_roupier
scrappier1544433scrappier
screecher16144483screecher
screechier1742983screechier
screener1037573scree_ner
screwier1346433scr_ewier
scrimpier1554243scrimpier
seedier83513633_seedier
sheenier11167423sheenier
sleekier1245573sleekier
sleeper93211563sleep_er
sleetier837883sleetier
sneerier878103sneerier
sneezier1774333sneezier
speedier1146623speedier
steelier839193steelier
steeper93812773steep_er
sweeper12329373sweep_er
teenier72611143_teenier
trampier12318243trampier
trendier937913trendier
tressier847963tressier
trippier1246623trippier
tweedier1253623tweedier
weedier113810623_weedier
weenier103210803_weenier
weeper114313303_weep_er
weepie11258793_weepie_
weepies122811743_weepies
wheezier2333343wheezier

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.436409841.7
2DLD Change Limit1461621977.09320606.5
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.60523496.5
 
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.