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

57 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
aquarian174701(None) 
aquaria1638041aquaria_
aquarial1746631aquarial
aquarians1845871aquarians
agrarian948252agrarian
apiarian1048322apiarian
aquarist171010082aquarist
aquarium1945382aquarium
quartan1636422_quartan
acaridan1165233a_caridan
actuarial1144973actuarial
adularia945053adularia_
adularias1044993adularias
aequorin1743483aequori_n
agrarians1045793agrarians
angaria8311583angaria_
angarias9310553angarias
antiquarian2055283antiquarian
anuran64313243anu_r_an
anuria6313123anu_ria_
anurias7312253anu_rias
apiarians1146653apiarians
aquaplane2052493aquaplane
aquarists1856123aquarists
aquariums2043953aquariums
aquatic1838113aquati_c
aquatics1945893aquatics
aquatint1749433aquatint
aquavit1945203aquavi_t
aquavits2043893aquavits
araucarian1253063araucarian
arcadian1147763arcadian
barbarian1346343barbarian
caesarian1147053caesarian
calvarian1446863calvarian
casuarina1144973casuarina
cesarian1048183cesarian
durian7312003_du_rian
equation17310483equation
filarian1148313filarian
guardian1045113_guardian
iguanian943553iguanian
lunarian847293lunarian
malarian10311563malarian
ovarian1037643_ovarian
pagurian1144613pagu_rian
parian83223963__parian
qualia1559563_qualia_
quartans1736283_quartans
quatrain1745823_quatrain
riparian1047523riparian
rosarian847593rosarian
saurian739913sau_rian
squaring18158633squaring
squarish2047323squarish
taqueria1743403taqueria_
taquerias1843533taquerias

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.1531167915.0
2DLD Change Limit146162576.58022213.1
3Display Results57570.0163562.5
 (SQL Overall)178691576.74926476.7
 
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.