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

477 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
creaky15491155(None) 
creak115418431creak_
creaks124315961creaks
creamy134811361creamy
creasy114612301creasy
croaky15528481croaky
freaky16439231freaky
screaky16436211screaky
beaky146118022_beaky
braky145015812br_aky
bready124511182bready
break115319402break_
breaks124816422breaks
caky136222442c__aky
cheeky18448612cheeky
cracky175010222cracky
crake114823522cr_ake
cranky153910632cranky
crazy195511222cr_azy
creaked143413232creaked
creakily1735392creakily
cream95721342crea_m
creams104715252creams
crease85519572crease
create85126372create
creek114917392creek_
creeks124812922creeks
creepy13418802creepy
crepey135110932crepey
crepy124812702cre_py
cressy11439112cressy
croak115216632croak_
croaks125812982croaks
dreamy12509992dreamy
dreary104611672dreary
drecky16486332drecky
freak125115242freak_
freaks134713062freaks
greasy10419462greasy
leaky125217722_leaky
peaky145718152_peaky
ready94821502_ready
reeky125416262_reeky
screak125311052screak_
screaks13469352screaks
sneaky13427842sneaky
streaky14447812streaky
treaty94414352treaty
tweaky1634022tweaky
wreak125513272wreak_
wreaks134711112wreaks
acreage1037833acreage
already1144263already
apeak115513453apeak_
arak86929573ar_ak_
araks94820883ar_aks
area45843393area__
areae55229743area_e
areal55928733area_l
areally10411243areally
areas55935773area_s
areaway1335913areaway
ariary94114203ariary
array86317143arra_y
aweary1237303aweary
beady114719923_beady
beak106534383_beak_
beaks115326623_beaks
beamy126218573_beamy
berake124216083berake
bleak115915383bleak_
bleakly1634663bleakly
bleaks125112433bleaks
bleary115112553bleary
brake116025343br_ake
braxy175410893br_axy
bray95232903br_a_y
breach134213723breach
bread85523113brea_d
breads95419203breads
breaker133912923breaker
breakup1543463breakup
bream95121813brea_m
breams104815043breams
breast8319633breast
breath113916263breath
breathy15328033breathy
breeks125310793breeks
breezy20295853breezy
briary114912003briary
bricky17489093bricky
cagy106321993c__agy
cake105439963c__ake
cakey145517273c__akey
canary11314693canary
caretake1446773caretake
casky144512683c_asky
cavy125920003c__avy
cay87155983c__a_y
cease75227653c_ease
cedary12419603cedary
cerate84829463cerate
cereal8315833cerea_l
cereals9313173cereals
chalky18468773chalky
chary135023133c_hary
chay124924873c_ha_y
cheap126915943chea_p
cheaply1735023cheaply
cheapo134810083cheapo
cheaps134613683cheaps
cheat105732453chea_t
cheats114519543cheats
check164714713check_
checks174912703checks
cheek145115713cheek_
cheeks154712783cheeks
cheery144913153cheery
cheesy14419193cheesy
cherry144810763cherry
cherty144612473cherty
chesty144610503chesty
chevy16479993che_vy
chewy165011903che_wy
chinky185610543chinky
choky175711223c_hoky
chucky20418003chucky
chunky18468273chunky
clanky15469073clanky
clary105719613c_lary
clay95927413c_la_y
clean75420413clea_n
cleanly1236323cleanly
cleans85817053cleans
clear76219053clea_r
clearly1236663clearly
clears84116563clears
cleat76335063clea_t
cleats84919313cleats
cleave114212513cleave
cleek115514913cleek_
cleeks125010543cleeks
clergy1234993clergy
clerk115812453clerk_
clerkly1643573clerkly
clerks12458843clerks
cloak115214013cloak_
cloaks124411263cloaks
clunky15447893clunky
coaly105521593c_oaly
cocky164215933c_ocky
coky137526823c__oky
comake144413423comake
conky145818743c_onky
cooky145321363c_ooky
copay126516313copa_y
corky145221153c_orky
covary1438743covary
craal74117753cr_aal
craals84113303craals
crab85727673cr_a_b
crabby15346753crabby
crabs95421393cr_abs
crack134120533cr_ack
crackly18397703crackly
cracks144817003cracks
craft105327663cr_aft
crafty14478913crafty
crag75625303cr_a_g
craggy13396603craggy
crags85622573cr_ags
crakes124921813cr_akes
cram85635493cr_a_m
cramp115120693cr_amp
crampy154710993crampy
crams96229153cr_ams
crane75331603cr_ane
crank114819613cr_ank
crankly16358123crankly
cranks125015313cranks
cranny114210273cranny
crap85731843cr_a_p
crape96128443cr_ape
crappy15446803crappy
craps95328643cr_aps
crash109120013cr_ash
crass76328043cr_ass
crate76537403cr_ate
crave105626313cr_ave
craw97725263cr_a_w
crawl104916713cr_awl
crawly144610763crawly
craws105723123cr_aws
craze165221463cr_aze
creakier14328333creakier
creaking153414113creaking
creamed123913713creamed
creamer113714083creamer
creamery15385973creamery
creamily1536363creamily
creased104315583creased
creaser94415723creaser
creases94020963creases
created104323443created
creates95225173creates
creatin93618133creatin
creator93714433creator
creche13310763creche
cred76530883cre__d
credal9311673credal
credit9315193credit
credo84815563cre_do
credos94612843credos
creds85418773cre_ds
creed85727393cre_ed
creeds94714773creeds
creel75121483cre_el
creels84416943creels
creep95218103cre_ep
creeps104213623creeps
creese84014333creese
creesh11328333creesh
cremate113816183cremate
creme94319323cre_me
cremes104517993cremes
crenate93317113crenate
crenel84213063crenel
creole8913723creole
crepe95520723cre_pe
creped114115703creped
crepes105419343crepes
crepon1039933crepon
crept95125893cre_pt
cresol8310203cresol
cress75022833cre_ss
crest74632693cre_st
crests85218703crests
cresyl1135133cresyl
cretic102816283cretic
cretin82917913cretin
crew96122673cre__w
crewed125316553crewed
crewel114310473crewel
crews105917493cre_ws
crick135118753crick_
crickey18418143crickey
cricks144316053cricks
crikey15317783crikey
crimpy15489393crimpy
crinkly16387523crinkly
crispy13478563crispy
croaked143710533croaked
croaker133010683croaker
croakily1744733croakily
crock135921993crock_
crocks145118423crocks
crony105918673cr_ony
crook115217573crook_
crooks124914413crooks
croupy13458733croupy
crowdy15467173crowdy
cruck135615323cruck_
crucks144412583crucks
cruddy1334193cruddy
cruelly1236553cruelly
cruelty1234113cruelty
crumby15408113crumby
crummy15365893crummy
crusty114911343crusty
cry89726243cr___y
crybaby1941933crybaby
curacy1339593curacy
deary95826843_deary
deray95024183dera_y
drake104918303dr_ake
dray85428093dr_a_y
dread74419023drea_d
dreads84115023dreads
dream85120393drea_m
dreams94513983dreams
dreamt94615713dreamt
drear65016903drea_r
drears74614253drears
dreck124812803dreck_
drecks13459203drecks
dreggy12364633dreggy
drek96321083dre_k_
dreks105714743dre_ks
dressy10518143dressy
drosky14486163drosky
easy76224493__easy
flaky155715583_flaky
flecky18387653flecky
fray105428903fr_a_y
freaked15399703freaked
freakily1835003freakily
freckly19124593freckly
freely12310953freely
frenzy2135883frenzy
fretty1249223fretty
friary124010093friary
frisky16406673frisky
geeky134710733_geeky
gleamy12398113gleamy
grapy115416433gr_apy
gravy125512113gr_avy
gray85329893gr_a_y
grease75416233grease
great66034243grea_t
greatly1137613greatly
greats76318393greats
greave104611493greave
greedy11518843greedy
greek105915943greek_
greeny104811453greeny
gremmy1454473gremmy
grey85624043gre__y
greyly13316543greyly
heady125117263_heady
heapy135914983_heapy
heavy144814183_heavy
jerky196712423_jerky
laky116725823__laky
leady95618603_leady
leafy116316213_leafy
leak86233713_leak_
leaks95923913_leaks
leary85927383_leary
leavy115715773_leavy
mealy104422183_mealy
meany104620473_meany
meaty107021313_meaty
oaky116419953__oaky
ocrea73311823ocrea__
ocreae83310273ocrea_e
ocreate93711743ocreate
oread64619603orea_d
oreads73915773oreads
peak106535203_peak_
peaks114825623_peaks
peaty105725693_peaty
peavy135014843_peavy
pecky165515093_pecky
perky145319483_perky
pesky145911563_pesky
phreak1536153phreak_
phreaks1634543phreaks
pray96331533pr_a_y
preach133613923preach
preachy17307313preachy
preact103220393preact
preamp1238993preamp
prearm104512343prearm
prebake1539093prebake
prebuy1357423prebuy
predry1237863predry
prelacy1437583prelacy
prepay13310313prepay
preppy1235523preppy
pretty11510873pretty
prexy174611573pre_xy
prey96228483pre__y
pricky174210343pricky
quaky214310743_quaky
queasy1855173queasy
queazy2743573queazy
racy95825683_r_acy
rake84841573_r_ake
raki87127833_r_aki
raku85423773_r_aku
ray66361993_r_a_y
reach105123883_reach
react74634333_react
read55942533_rea_d
readd74617133_readd
reads64835273_reads
real45750293_rea_l
really93315613_really
realm75621623_realm
reals55038653_reals
realty92713693_realty
ream65841613_rea_m
reams75729623_reams
reap65934743_rea_p
reaps75626193_reaps
rear45644553_rea_r
rearm75923563_rearm
rears54739653_rears
reata54225393_reata
reave84528023_reave
rebuy104714683_rebuy
reck106130563_reck_
recks115625133_recks
redly94217193_redly
redry94314363_redry
reedy910020283_reedy
reefy114217703_reefy
reek85232523_reek_
reeks94124033_reeks
refly113914563_refly
refry114412463_refry
reify114814973_reify
rekey124014733_rekey
relay84424673_relay
rely75428953_re_ly
remake124016113_remake
repay104818453_repay
reply104015853_reply
resay85320543_resay
retake104718533_retake
retry84718083_retry
rewake135218463_rewake
risky126311523_risky
rocky144513853_rocky
rooky126117623_rooky
screaked15246973screaked
scream104814243screa_m
screams114810613screams
screwy14659453scre_wy
seamy105921273_seamy
shaky154616843_shaky
sleazy18267393sleazy
sleeky13398963sleeky
smeary114110803smeary
snaky125113913_snaky
sneak96016173sneak_
sneaks104312493sneaks
speak114618673speak_
speaks125114583speaks
squeaky2343073squeaky
steady103510203steady
steak95219803steak_
steaks104415853steaks
steamy115112373steamy
streak104613623streak_
streaks114411273streaks
streamy12509483streamy
sweaty123710053sweaty
teak85930843_teak_
teaks94222903_teaks
teary85124053_teary
thready14435903thready
tray77632593tr_a_y
treacly1237093treacly
tread64821703trea_d
treads74817913treads
treat56240353trea_t
treats64821693treats
trebly1138973trebly
trek86222313tre_k_
treks96016853tre_ks
trendy10469603trendy
tressy9448553tressy
trey77228793tre__y
tricky154211473tricky
troak95213573troak_
troaks104410593troaks
tweak1257753tweak_
tweaks1335963tweaks
uneasy9278853uneasy
unready11215943unready
urea46528053urea__
ureal56722683urea_l
ureas55826013urea_s
urease64516993urease
vealy115817773_vealy
weak117126303_weak_
weakly1636483_weakly
weary115620613_weary
whelky19314973whelky
wreaked15369023wreaked
wreaker143610043wreaker
wreath124111193wreath
wreathy16326063wreathy
wreck144611043wreck_
wrecks15418883wrecks
yeuky15547033_yeuky

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164776.40617595.4
3Display Results4774770.1403407.1
 (SQL Overall)1786914776.68626726.1
 
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.