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 “rosaria” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
rosaria74925(None) 
rosarian847591rosarian
fusaria1046222fusaria
rosacea944712rosacea
rosarians945792rosarians
rosaries8312782rosaries
rosarium10126922rosarium
rosary92810352rosar_y
rostra6310932rostr_a
solaria7312492solaria
zoaria1548382zo_aria
angaria8311583angaria
aquaria1638043aquaria
aria46245423___aria
bothria1246443bothria
cesarian1048183cesarian
coria75828323co__ria
drosera836203droser_a
dysuria1144923dysuria
filaria1039653filaria
hosanna1044063hosanna
leprosaria1253063leprosaria
logania847833logania
malaria9313703malaria
maria75032883__maria
mojarra1642513mojarra
monarda1046613monarda
mosaic10311143mosa_ic
noria55722183no__ria
nostril749303nostril
notarial8410753notarial
ocarina948033_ocarina
osar46820953_osar__
ossia53710403_os_sia
ostia52315583_os_tia
ovarial1037613_ovarial
ovarian1037643_ovarian
posada937163posa_da
progeria1147943progeria
propria1149933pro_pria
prosaic11311163prosa_ic
puparia1147353puparia
raia46638383r__a_ia
rasorial848223rasorial
ratafia1045773ratafia
realia6314593r_ealia
regalia839223regalia
resaid74517083resa_id
resail64418733resa_il
riparian1047523riparian
ristra6310713ristr_a
roadie72813813ro_adie
roar46328573ro_ar__
roared75015393ro_ared
roarer63914333ro_arer
roaring82916003ro_aring
roars55622243ro_ar_s
romaji1534893romaji_
romajis1635913romajis
rosaceas1043723rosaceas
rosariums11124773rosariums
rosehip1244623rosehip
roseola777053roseola
roseries8317323roseries
rosery93813283roser_y
roshi8310753ros_hi_
roshis9311793ros_his
rosin55325313ros__in
rosolio746983rosolio
rostral7311333rostral
rostrum947223rostrum
rotaries8315693rotaries
rotary92411303rotar_y
sari45444043__sari_
sarin55239253__sarin
saris54544953__saris
sharia93116733_sharia
solatia7312253solatia
souari6311383souari_
souaris7312333souaris
stria55723213__stria
sudaria847973sudaria
talaria7412523talaria
tsarina736653_tsarina
varia85824203__varia
velaria1038923velaria
vivaria1346983vivaria
wistaria1146623wistaria
zoarial1646923zo_arial

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 Filter1786911340270.420425454.8
2DLD Change Limit134027896.31321230.3
3Display Results89890.0332697.0
 (SQL Overall)178691896.76626410.1
 
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.