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

258 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
crestal931213(None) 
crustal939021crustal
crystal1237431crystal
agrestal945652agrestal
cental84420962c_ental
cesta75419482c_esta_
cestas85018542c_estas
coastal9411042coastal
costal85419512c_ostal
credal9311672cre_dal
creedal1037092creedal
cresol8310212cres_ol
crest74632692crest__
crested103416552crested
crests85218702crest_s
cresyl1135132cres_yl
crissal937412crissal
crista8311802crista_
cristae9310612cristae
cryptal1445682cryptal
crystals1347172crystals
cuesta838512cuesta_
cuestas957932cuestas
festal94213562_festal
forestal11410282forestal
rectal84418142_rectal
rental63922032_rental
reseal64819652_reseal
vestal94615572_vestal
abettal946073abettal
acetal84314903ace_tal
areal55928743are__al
argental947933argental
arista6415293arista_
aristae7312533aristae
aristas7413533aristas
arsenal739383arsenal
artal55525483ar__tal
bestial9311643_bestial
borstal939043borstal
bristol937053bristol
brutal859383br_utal
cabresta1243993cabresta_
cabrestas1344023cabrestas
caecal103713733cae_cal
caesar8410943caes_ar
caestus947773caestus
caesural1055403caesural
cantal84122033c_antal
capital112311523capital
capstan1137913capstan
casual81112873c_asual
causal81413203caus_al
cecal94619113c_e_cal
celesta947643celesta_
celestas1057083celestas
celestial1146153celestial
censual937663censual
centai84814783c_entai
centals94317053c_entals
centas85020703c_entas
central93114473c_entral
ceramal1138843ceramal
cercal10314123c_ercal
cereal8315833c_ereal
cerebral1266183cerebral
cesti75217423c_est_i
cestoi84511953c_estoi
cestos84718093c_estos
cestus84412913c_estus
chaetal1238283chaetal
chasmal14158213chasmal
cheetah1545453cheetah
chest104926143chest__
chested133811683chested
chestful1644243chestful
chestily1645523chestily
chests114916263chest_s
chesty144610503chest_y
chetah14399583che_tah
chital114313883c_hital
chrismal1575173chrismal
cliental1045363cliental
coequal1844943coequal
coeval1138893coe_val
coital84117053c_oital
cornstalk1543943cornstalk
costa75523733c_osta_
costae85319683c_ostae
costar85518613c_ostar
craal74117753cr__aal
cranial92114683cranial
creak115418433cre__ak
cream95721353cre__am
creatable1339563creatable
create85126383creat_e
created104323463created
creates95225213creates
creatin93618133creatin
creator93714453creator
creatural1144913creatural
creel75121483cre__el
cremate113816183cremate
crenate93317113crenate
crenel84213063cre_nel
crenshaw1642433crenshaw
creosol946053creosol
crept95125893crept__
cresols939653cresols
cress75022833cres__s
cresses94219813cresses
cresset93319943cresset
cressy11439113cres_sy
cresting114017043cresting
cresyls1234753cresyls
cretic102816283cre_tic
cretin82917913cre_tin
crewel114310483cre_wel
crewman1435753crewman
crissa837623crissa_
cristate10310603cristate
crosstalk1543893crosstalk
crucial1157893crucial
crural8610633cr_ural
crust75827663crust__
crusted103712763crusted
crustily13328173crustily
crusts84916543crust_s
crusty114911343crust_y
cryostat1395743cryostat
cubital1137103cubital
curtal83914543c_urtal
cuspal1037883c_uspal
decretal1146353decre_tal
dental74319173_dental
distal73615773_distal
drest65530343drest__
egesta7428653egesta_
estral64716513__estral
excretal1764353excre_tal
eyestalk15123173eyestalk
fetal85623373_fe_tal
fiesta938123fiesta_
fiestas1038433fiestas
foetal9311883foe_tal
forestall1246913forestall
forestay1448193forestay
forestial1247233forestial
fractal1237623fractal
fresnel1035893fresnel
fretsaw1343923fretsaw
frontal1038363frontal
frusta937453frusta_
gestalt8411173_gestalt
gremial1039153gremial
hyetal1236543hye_tal
instal6712193_instal
loessal744393loessal
meatal84114733_meatal
mental84521603_mental
mescal104113493_mescal
mesial84818083_mesial
metal75427383_me_tal
omental93210423omental
orbital936923orbital
oriental848493oriental
parental10310953parental
pedestal1146403pedestal
petal76526893_pe_tal
postal84317533_postal
preanal9310713preanal
predial103815413predial
premeal11310523premeal
prenatal1048373prenatal
preoral9312673preoral
presa74319043pres_a_
presale9416353pres_ale
presell939303presell
presoak1348453presoak
prest75736353prest__
prestamp1445323prestamp
prester93519623prester
presto84216203prest_o
prestos93716093prestos
prests84021263prest_s
pretax152310193pre_tax
rascal8511123_rascal
ratal55025113_r_atal
real45750293_re__al
reata54225393_reata_
reatas64021023_reatas
recital9412173_recital
recoal84117983_recoal
recta74220263_recta_
redial74923113_redial
redtail858713_redtail
refutal1046943_refutal
regal65023793_re_gal
regnal74812933_regnal
renal55929513_re_nal
rentals74017483_rentals
repeal84718293_repeal
resail64418733_resail
resale64025543_res_ale
resat55139683_res_at
resaw84117253_res_aw
resay85320543_res_ay
rescale93215483_rescale
reseals73917683_reseals
reseat64131493_reseat
reseau64216213_reseau
resell64215203_resell
resoak10311093_resoak
rest46459843_rest__
restable101618443_restable
restack1339433_restack
restaff1339013_restaff
restage83316193_restage
restamp1146483_restamp
restart7320033_restart
restate73824883_restate
rested74430783_rested
rester63832433_rester
restful1038623_restful
restoral8810983_restoral
rests54935873_rest_s
restyle1038763_restyle
retag63618413_re_tag
retail65522073_re_tail
retax124517973_re_tax
retial64724993_retial
retotal739843_retotal
retral64419743_retral
reveal94115063_reveal
rictal83113193_rictal
rostral7311333_rostral
scrotal938493scr_otal
septal84513383_septal
setal56430903_se_tal
siesta639503siesta_
siestas738813siestas
tectal83713253_tectal
testa54822043_testa_
testae64216253_testae
tressel73010893tressel
trestle72611363trestle
ureal56722683ure__al
uredial82910483uredial
versal93013753vers_al
vesta86618303_vesta_
vestals104612333_vestals
vestas95916683_vestas
vestral104111013_vestral
wrest84925433wrest__
wrested113410933wrested
wrester102812413wrester
wrestle10298843wrestle
wrests95313083wrest_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 Filter1786911340270.483369960.7
2DLD Change Limit1340272586.86019537.5
3Display Results2582580.1102345.5
 (SQL Overall)1786912587.45323975.7
 
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.