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

68 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
rasorial84822(None) 
armorial1049452armorial
asocial998652_asocial
manorial10311082manorial
raptorial1147432raptorial
aboral8314373_abor_al
aerial64625713_a_erial
alodial899953_alodial
amoral8314633_amor_al
aortal65217513_a_ortal
aporia8315863_aporia_
aporias9315153_aporias
arboreal1045633arboreal
armorials1145653armorials
arterial8313633arterial
asocials1075683_asocials
astral66919283_astr_al
atrial65418943_a_trial
baronial1049483baronial
basidial1145623basidial
cantorial1149813cantorial
caporal11410943capor_al
censorial11117503censorial
chorial124214143_chorial
curatorial1245363curatorial
cursorial1144603cursorial
eusocial1045463eusocial
factorial1447023factorial
fascial1258303fas_cial
fossorial1243793fossorial
gastral8329553gastr_al
haustorial1344503haustorial
malarial10410613malarial
manurial1047793manurial
material10314103material
mayoral1237693mayor_al
memorial1249523memorial
mistrial10311383mistrial
narial6317953na__rial
nasial6413283nas__ial
oratorical1245163oratorical
pastoral10310483pastor_al
praetorial1257093praetorial
pretorial11512653pretorial
rachial122012173ra_chial
racial83419243ra__cial
radial74020393ra__dial
rasbora945943rasbor_a_
rasboras1045893rasbor_as
rascal8511123ras__cal
razorbill2051313razorbill
razoring1836443razoring
reburial1046203reburial
rectorial11119893rectorial
restoral8810983restor_al
retrial7615553r_etrial
rosaria749253rosaria_
rosarian847593rosarian
rostral7311333rostr_al
sartorial948383sartorial
sensorial9117453sensorial
serial64625863__serial
social8813333__social
tensorial9116793tensorial
tonsorial9116743tonsorial
tutorial847833tutorial
unsocial1046073unsocial
uxorial1446323_uxorial

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 Filter1786911461620.423422437.4
2DLD Change Limit146162686.60622125.6
3Display Results68680.0332060.6
 (SQL Overall)178691687.06225303.2
 
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.