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

174 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
rostral731133(None) 
rostra6310931rostra_
astral66919282_astral
austral73411512austral
costal85419512cost_al
costrel9310372costrel
estral64716512_estral
gastral8329552gastral
lustral7339652lustral
mistral91013642mistral
nostril749302nostril
osteal6312962_osteal
postal84317532post_al
postoral10311722postoral
postural1049202postural
restoral8810982restoral
retral64419742r_etral
ristra6310712ristra_
ristras7311562ristras
rostrally1246092rostrally
rostrate8313842rostrate
rostrum947212rostrum
vestral104111012vestral
antral65719413_antral
aortal65217513aort_al
arbitral1045423arbitral
astrals75515243_astrals
astray95615543_astray
australs8359533australs
bestial9311643bestial
boral75831703bo__ral
borstal939043borst_al
central93114473central
citral81113893_citral
cloistral1143543cloistral
coastal9411043coast_al
coistrel1046743coistrel
coistril1046763coistril
coital84117053coit_al
colostral1145493colostral
construal1146793construal
contra83314703contra_
contrail10410983contrail
contras93015623contras
control9310693control
coral76033453co__ral
corral83616253co_rral
costa75523733cost_a_
costae85319683cost_ae
costar85518613cost_ar
costard104113353costard
costars94218013costars
costrels1038933costrels
crestal9312133crest_al
crustal939023crust_al
crystal1237433cryst_al
dextral1577003dextral
diastral946993diastral
dioptral1144683dioptral
distal73615773dist_al
doctoral1146303doctoral
dossal75510303dos_sal
dotal64919623do_t_al
dottrel834463dottrel
drosera836203drosera_
droseras935873droseras
dustrag945363dustrag
estray95713333_estray
estrual7367933_estrual
festal94213563fest_al
foetal9311883foet_al
fontal9313143font_al
frontal1038363front_al
gestural946033gestural
gomeral1038833gomeral
gooral7310463go_oral
goral65125753go__ral
horal86328683ho__ral
hosta85917833host_a_
hostas94515823host_as
hostel93914153host_el
instal6712193inst_al
kestrel1137113kestrel
loral55927823lo__ral
lustra6358893lustra_
mistrals101212623mistrals
mistrial10311383mistrial
mitral81314323_mitral
moral75533433mo__ral
mortal84616853mort_al
neutral737923neutral
nonoral7313603nonoral
nostrils848183nostrils
nostrum946953nostrum
notal55221353no_t_al
octal71214723_oct_al
oral47638123_o__ral
osetra667423_osetra_
osetras737323_osetras
ostia52315583_ostia_
ostraca937823_ostraca
ostraka1144833_ostraka
outran63218893_outran
pastoral10310483pastoral
pastural1038413pastural
peytral1287503peytral
plastral1046913plastral
poitrel936193poitrel
portal84218463port_al
portray1237483portray
postals93716373post_als
postanal1048053postanal
postbag1245223postbag
postgrad1245493postgrad
postman112410043postman
postrace12310543postrace
posttax1645533posttax
posttrial1146513posttrial
postwar1236903postwar
procural1246923procural
prosomal1248543prosomal
prostrate11412483prostrate
proviral1346493proviral
rascal8511123ras_cal
rasorial848223rasorial
ratal55025113r_at_al
rattrap945263rattrap
rectal84418133rect_al
rental63922023rent_al
reseal64819643res_eal
respray1236503respray
restart7320033restart
restful1038623restful
restorals978073restorals
restrain8311703restrain
retial64724993r_etial
retrial7615553r_etrial
rictal83113183rict_al
ritual6310623r_itual
rootcap1143973rootcap
rorqual1663573rorqual
rosaria749253rosaria
rosarian847593rosarian
rosary92810353rosar_y
rosebay12135773rosebay
roseola777053roseola
rosery93813283roser_y
rosinol756323rosinol
rostella845493rostella
roster64329083rost_er
rosters73727543rosters
rostrums1046083rostrums
rota45834343ro_t_a_
rotary92411303ro_tary
rotas54827723ro_t_as
rotl45029683ro_t__l
royal85014703ro__yal
ruderal837373ruderal
rural55821173r__ural
rustical1048393rustical
seral56336383__seral
sistra639333sistra_
sororal7310653sororal
steal56125473__steal
strap77925263__strap
straw813321293__straw
stray88525573__stray
sural55931263__sural
total55321823to_t_al
unstrap946783unstrap
ventral103612173ventral
vestal94615573vest_al
vestural1156473vestural
wastrel1037553wastrel

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.403443402.0
2DLD Change Limit1340271747.00319138.5
3Display Results1741740.0602900.0
 (SQL Overall)1786911747.46623934.0
 
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.