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

61 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
aquarial174663(None) 
aquaria1638041aquaria_
aquarian1747011aquarian
actuarial1144972actuarial
aquarians1845872aquarians
aquarist171010082aquarist
aquarium1945382aquarium
abaxial1646183a_baxial
abbatial1284673abbatial
adagial946373a_dagial
adaxial1545323a_daxial
adularia945053adularia_
adularias1044993adularias
aerial64625713a__erial
agrarian948253agrarian
angaria8311583angaria_
angarias9310553angarias
anural65714743anu_r_al
anuria6313123anu_ria_
anurias7312253anu_rias
apiarian1048323apiarian
aquarelle1852963aquarelle
aquarists1856123aquarists
aquariums2043953aquariums
aquatic1838113aquati_c
aquatics1945893aquatics
aquatint1749433aquatint
aquavit1945203aquavi_t
aquavits2043893aquavits
armorial1049453armorial
arterial8313633arterial
atrial65418943a__trial
audial7312993a_u_dial
aural54428963a_u_r_al
burial84117623_bu_rial
calvarial1445693calvarial
curial84019153_cu_rial
equatorial1954203equatorial
estuarial943933estuarial
filarial1147863filarial
gharial1137343_gharial
malarial10410613malarial
manubrial1342943manubrial
manurial1047793manu_rial
narial6317953__narial
notarial8410753notarial
ovarial1037613_ovarial
puparial1246313puparial
quail144314363_qua_i_l
qualia1559563_qualia_
quantal16367893_quantal
quarrel1636103_quarrel
quartan1636423_quartan
sacrarial1146523sacrarial
squaring18158633squaring
squarish2047323squarish
taqueria1743403taqueria_
taquerias1843533taquerias
urial54823023__u_rial
vicarial1347793vicarial
zoarial1646923_zoarial

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 Filter1786911461620.423422437.4
2DLD Change Limit146162616.34323043.0
3Display Results61610.0163812.5
 (SQL Overall)178691616.78226347.8
 
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.