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

157 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
creepie113748(None) 
creepier1236251creepier
creepies1239611creepies
cheapie1437562cheapie
crappie13298982crappie
creep95218102creep__
creepage1344342creepage
creeped12329712creeped
creeper11339982creeper
creepiest1337062creepiest
creepily1574952creepily
creeping133310102creeping
creeps104213622creep_s
creepy13418802creep_y
creese84014332cree_se
crepe95520722cr_ep_e
crepier1139742cr_epier
croppie13278792croppie
freebie1236042freebie
greenie8310122greenie
preemie11310562preemie
preppie1058092preppie
weepie11258792_weepie
breeze17298963bree_ze
breezier1934533breezier
cepe84926653c__ep_e
chappie16298663chappie
cheapies1539033cheapies
cheekier1735103cheekier
cheep125416503cheep__
cheeped153410593cheeped
cheeper143610743cheeper
cheeping16329553cheeping
cheeps135312913cheep_s
cheerier1348003cheerier
cheerio12379313cheerio
cheese113812763chee_se
cheesier1335963cheesier
chippie16297693chippie
clepe94617383c_lep_e
coterie9417403coterie
cowpie133511513c_owpie
crampier14288903crampier
crampit1338863crampit
crape96128443cr_ap_e
crappier14288133crappier
crappies142911163crappies
creakier14328333creakier
creamier12319063creamier
crease85519573cr_ease
creasier103210193creasier
create85126383cr_eate
creatin93618133creatin
creatine103417413creatine
creative132812803creative
creche13310763cr_eche
credence1387823credence
credit9315193cr_edit
creed85727393cree__d
creedal1037093creedal
creeds94714773cree_ds
creek114917393cree__k
creeks124812923cree_ks
creel75121483cree__l
creeled104012013creeled
creeling113513363creeling
creels84416943cree_ls
creepages1444303creepages
creepers12318633creepers
creepiness1444883creepiness
creeses93914623creeses
creesh11328333cree_sh
creeshed1435693creeshed
creeshes1336953creeshes
cremate113816183cremate
creme94319323cr_e_me
crenate93317113crenate
crenelle1046333crenelle
creole8913733cr_eole
creolise1037863creolise
creolize1947183creolize
creped114115703cr_eped
crepes105419343cr_epes
crepey135110933cr_epey
crepiest12310383cr_epiest
creping122913653cr_eping
crepon1039943cr_epon
crept95125893cr_ep_t
crepy124812703cr_ep_y
crescive1545283crescive
cretic102816283cr_etic
cretin82917913cr_etin
crevice1436153crevice
crimpier14287323crimpier
crimple13408693crimple
cripe95521143cr_ip_e
cripple13378583cripple
crispier12297253crispier
croppies143111133croppies
croupe105114433croup_e
croupier1246883croupier
crowdie1335913crowdie
crummie1336153crummie
crumple13368363crumple
cutesie937963cutesie
eerie55228533__eerie
freebee1238043freebee
freebies1337873freebies
freesia1046323freesia
freeze18349513free_ze
greedier1036083greedier
greenier938713greenier
greenies9312673greenies
gremmie1264383gremmie
groupie1045783groupie
hempie132410563_hempie
kelpie12308613_kelpie
kewpie15465413_kewpie
kreep114610413kreep__
kreeps12427413kreep_s
peerie83617893_peerie
precipe133012123precipe
preedit10512463preedit
preemies12512193preemies
premie103617993pr_emie
preppier1156643preppier
preppies1149693preppies
recipe103414893_recipe
reedier83815303_reedier
reedit7617223_reedit
reefier102912553_reefier
reekier113111123_reekier
reemit8717223_reemit
reeve84121323_ree_ve
repin75324703_r_epin
repine85627813_r_epine
respire9411543_respire
respite9513033_respite
retie55735303_r_etie
reverie103615163_reverie
scrapie115010943scr_apie
seepier92912013_seepier
sheenie10159493sheenie
sleepier1036783sleepier
steelie7310213steelie
steeple937323steeple
sweepier1355493sweepier
sweetie10157873sweetie
teepee8314363_teepee
treelike1237003treelike
trepid9310083tr_epid
veepee11311483_veepee
weenie92612023_weenie
weepier12319273_weepier
weepies122811743_weepies
wheelie1336193wheelie
wheeple1534853wheeple

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340271576.31321230.3
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.79626293.6
 
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.