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

56 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
sacraria104739(None) 
sacrarial1146521sacrarial
acrasia9310032_acrasia
sacrarium1344472sacrarium
acacia10311353_ac_acia
acari75020283_ac_ari_
acarid95017063_ac_arid
acrasias1048893_acrasias
acrasin9311223_acrasin
acromia1139963_acromia
agrarian948253_agrarian
angaria8311553_angaria
apraxia1646893_apraxia
aquaria1638033_aquaria
arcadia1039703_arcadia
ascarid103910713asc_arid
ascaris93613323asc_aris
baccara1347143baccar_a
bacteria1248983bacteria
calcaria1249523calcaria
caldaria1148943caldaria
calvaria1347873calvaria
cercaria1246953cercaria
crania82418433__crania
lacunaria1143793lacunaria
malaria9313693ma_laria
pancratia1344633pancratia
saccadic1244173saccadic
saccharic1553793saccharic
saccharin1644523saccharin
sacra74516993sac__r_a
sacral83414413sacra__l
sacralize2048973sacralize
sacrals93311793sacra_ls
safari91110223sa_fari_
safaris101110663sa_faris
safranin1145213safranin
salariat8416303sa_lariat
samara8313853sa_mar_a
samsara936913samsar_a
sangria838113sa_ngria
sanitaria947063sanitaria
santeria8311643santeria
sapraemia1353353sapraemia
sapremia1245203sapremia
satara6315533sa_tar_a
savarin10310003sa_varin
scoria8513483s_c_oria
scrapie115010943s_crapie
sectarian1147533sectarian
septaria1047413septaria
sharia93116723s__haria
solaria7312493s_olaria
sudaria847973s_udaria
talaria7412503ta_laria
terraria847003terraria

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.1701051123.5
2DLD Change Limit146162568.34317519.1
3Display Results56560.0331697.0
 (SQL Overall)178691568.54620909.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.