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

254 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
cresyl113513(None) 
cresol8310211cresol
cresyls1234751cresyls
creasy114612302creasy_
credal9311672credal
creel75121482cre_el
crenel84213062crenel
creosol946052creosol
crepy124812702crepy_
cresols939652cresols
cress75022832cres_s
cressy11439112cressy
crest74632692cres_t
crestal9312132crestal
crests85218702crests
cresylic1543082cresylic
crewel114310482crewel
acetyl11396553acetyl
acres76327763acres__
adenyl1035023adenyl
areal55928733are_al
ares45871023ares__
artsy86012963artsy_
aryl75922343ar__yl
beryl101211673_beryl
brasil8713863brasil
brosy106115383brosy_
caecal103713733caecal
caesar8410933caesar
careful1249113careful
cares77369183cares__
caress85720263cares_s
causal81413203causal
cecal94619113c_ecal
cees65941593cees__
ceil65725063c_e_il
cel56040553c_e__l
cell65031723c_e_ll
ceorl7410923c_eorl
cercal10314123cercal
cereal8315833cereal
ceres75540013ceres__
cess65326053c_es_s
cesta75419483c_esta
cesti75217423c_esti
cheesy14419193cheesy_
chess105016923ches_s
chest104926143ches_t
chests114916263chests
chesty144610503chesty
chevy16479993chevy_
chewy165011903chewy_
chisel112111943chisel
chromyl17275233chromyl
cires74932913cires__
cissy104811073cissy_
coeval1138893coeval
consol82614113consol
consul82312303consul
cores76361853cores__
cosey106226713cosey_
coseys115215813coseys
cosy97232703c_osy_
craal74117753cr_aal
crases85532313crases
crash109120013cras_h
crasis85020473crasis
crass76328043cras_s
crassly1276653crassly
crawl104916713cr_awl
crawly144610763crawly
crazy195511223crazy_
creak115418433cre_ak
creaks124315963creaks
creaky154911553creaky
cream95721353cre_am
creams104715253creams
creamy134811363creamy
crease85519573crease
creased104315593creased
creaser94415743creaser
creases94020963creases
create85126383create
creche13310763creche
cred76530883cre__d
credit9315193credit
credo84815573cre_do
credos94612853credos
creds85418773cre_ds
creed85727393cre_ed
creedal1037093creedal
creeds94714773creeds
creek114917393cre_ek
creeks124812923creeks
creels84416943creels
creep95218103cre_ep
creeps104213623creeps
creepy13418803creepy
creese84014333creese
creeses93914623creeses
creesh11328333creesh
creme94319323cre_me
cremes104517993cremes
crenels93711013crenels
creole8913733creole
creosols1045723creosols
crepe95520723cre_pe
creped114115713creped
crepes105419343crepes
crepey135110933crepey
crepon1039943crepon
crept95125893cre_pt
cresses94219813cresses
cresset93319943cresset
crested103416543crested
cretic102816283cretic
cretin82917913cretin
crew96122683cre__w
crewed125316563crewed
crewels12438493crewels
crews105917503cre_ws
cries75438403cries__
cris66233433cris__
crises84529433crises
crisic103611843crisic
crisis83716343crisis
crisp95014623cris_p
crisply14426523crisply
crisps104411513crisps
crispy13478563crispy
crissa837623crissa
crissal937413crissal
crista8311803crista
crony105918673crony_
cross75124503cros_s
crosse85216313crosse
crossly1277273crossly
cruel74815903cr_uel
cruelly1236563cruelly
crural8610633crural
crus65828483crus__
cruse75726103crus_e
cruses88127713cruses
cruset84425093cruset
crush106815993crus_h
crusily12199093crusily
crust75827663crus_t
crustal939023crustal
crusts84916543crusts
crusty114911343crusty
cry89726243cr__y_
crystal1237433crystal
cues65438983cues__
cuesta838513cuesta
cures75645433cures__
curtesy1265833curtesy_
curtsy1156643curtsy_
cutesy114810733cutesy_
cyeses11510123cyeses
cyesis1148573cyesis
diesel74410403diesel
dreidl835233dreidl
dress65319833dres_s
dressy10518143dressy
drest65530343dres_t
freely12310963freely
fresco1136473fresco
fresh115012203fres_h
freshly16286833freshly
fresnel1035893fresnel
greasy10419463greasy_
grey85624043gre_y_
greyly13316543gre_yly
greys96614853gre_ys
grisly104310583grisly
heresy125011233heresy_
hexyl1844463_hexyl
ireful948713ireful
ires45639283ires__
ores46056683ores__
phenyl1435323phenyl
poesy105014063poesy_
presa74319043pres_a
presale9416353presale
prese75228383pres_e
presell939303presell
preset84430983preset
presold1059603presold
press75425953pres_s
prest75736353pres_t
presto84216203presto
prests84021263prests
prexy174611583prexy_
prey96228483pre_y_
preys105717783pre_ys
propyl13358183propyl
prosy106319253prosy_
protyl11308213protyl
real45750293_re_al
rebel73421293_rebel
redly94217203_redly
redye94413473_redye
reel45240533_re_el
refel84920813_refel
refly113914563_refly
regal65023793_regal
rely75428953_rely_
renal55929513_renal
reoil55321183_reoil
repel74921403_repel
reply104015853_reply
res35565043_res__
resail64418733_resail
resale64025543_resale
resat55139683_resat
resaw84117253_resaw
resay85320543_resay
resays93714153_resays
reseal64819653_reseal
resee54336333_resee
resell64215203_resell
reset55051863_reset
resew84519503_resew
resh76523453_res_h
resid64124093_resid
resile64627673_resile
resin54131053_resin
resit54241043_resit
resod64720053_resod
resold73915363_resold
resole64624183_resole
resow88217243_resow
rest46459843_res_t
rests54935873_rests
restyle1038763_restyle
result6318223_result
revel84423163_revel
rosy76024873_rosy_
screwy14659463screwy_
trebly1138973trebly
tres46542903tres__
tress55423163tres_s
tressel73010893tressel
tressy9448553tressy
trestle72611363trestle
trey77228793tre_y_
treys85018213tre_ys
trotyl9236673trotyl
uranyl936293uranyl
ureal56722683ure_al
versal93013753versal
wrest84925433wres_t
wrestle10298843wrestle
wrests95313083wrests

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.406440125.6
2DLD Change Limit1127162545.79619447.2
3Display Results2542540.0763342.1
 (SQL Overall)1786912546.27828463.0
 
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.