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

140 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
restoral881098(None) 
restorals978071restorals
bestowal1344512bestowal
estral64716512_est_ral
gestural946032gestural
pastoral10310482pastoral
pectoral121210502pectoral
postoral10311722postoral
rectorial11119892rectorial
restorable1246752restorable
restore75822982restor_e
restored96417192restored
restorer84813722restorer
restores85222992restores
retotal739842re_total
retral64419742re_t_ral
rostral7311332rost_ral
sectoral10109542sectoral
vestral104111012vest_ral
vestural1156472vestural
aestival1145483aestival
astral66919283_ast_ral
austral73411513aust_ral
bestial9311643best_ial
bestowals1443223bestowals
central93114473cent_ral
clitoral10106463clitoral
creatural1144913creatural
crestal9312133crest__al
dentural948083dentural
dextral1577003dext_ral
doctoral1146303doctoral
electoral1156733electoral
enteral73516443_enteral
enthral103410933_enthral
ephoral1248403_ephoral
estival1036323_estival
estray95713333_est_ray
estrual7367933_estrual
femoral1238723fe_moral
festal94213563fest__al
festival1444713festival
gastral8329553gast_ral
gestical1138993gestical
kestrel1137113kest_rel
litoral7610763_litoral
littoral845273littoral
lustral7339653lust_ral
mistral91013643mist_ral
nestor63713423nestor__
nestors73614973nestor_s
neutral737923neut_ral
pastorale1147323pastorale
pastorali1146243pastorali
pastorals1147953pastorals
pastural1038413pastural
pectorals13128153pectorals
peroral9314793pe_roral
peytral1287503peyt_ral
postural1049203postural
premoral1249713pre_moral
preoral9312673pre__oral
prestorage1344903prestorage
prestore104217353prestor_e
prestored125111673prestored
prestores114716083prestores
pretorial11512653pre_torial
raptorial1147433raptorial
rasbora945943rasbora_
rasboras1045893rasboras
rasorial848223ras_orial
recoal84117973re_co_al
rectal84418133rect__al
rector84019753rector__
rectorate11411373rectorate
rectors93520523rector_s
rectory123512733rector_y
referral1144403referral
regional9438783regional
remora8414593re_mora_
remoras9314073re_moras
removal1236733re_moval
rental63922023rent__al
reposal939113re_posal
reproval1355773reproval
rescore95616203rescor_e
rescored114513103rescored
rescores105415693rescores
reseal64819643res__eal
residual9245443residual
resoak10311093res_o_ak
resorb84914353res_or_b
resorbs95010523res_orbs
resort65728623res_or_t
resorts74817193res_orts
respool937643respo_ol
respray1236503res_pray
restart7320033restar_t
restarts8310873restarts
rester63832433rester__
resters74130403rester_s
restful1038623rest_ful
restock1338673resto_ck
restocks1437503restocks
restoke116113903resto_ke
restoked135710533restoked
restokes125213043restokes
restorers95110113restorers
restoring10314613restoring
restrain8311703rest_rain
restroom1047573restroom
restrove1138963restrove
retial64724993re_t_ial
retinal75318353re_tinal
retool63914483re_to_ol
retore67630773re_tor_e
retorn610923433re_tor_n
retort66831153re_tor_t
retorts76016513re_torts
retotals838463re_totals
retrial7615553re_trial
ristra6310713rist_ra_
ristras7311563rist_ras
rostra6310933rost_ra_
rustical1048393rustical
sectorial111110013sectorial
sporal82915453__sporal
stomal85213313__stomal
storax1389783__storax
tectorial11119033tectorial
teetotal844533teetotal
temporal1246333temporal
tentorial9119603tentorial
textural1544943textural
ureteral856233ure_teral
urethral1154633ure_thral
vectorial14147403vectorial
ventral103612173vent_ral
vesperal1344883vesperal
vestal94615573vest__al

Search took 9 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 Limit1461621407.72018932.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911408.20221786.3
 
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.