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

66 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
aquarist17101008(None) 
aquarists1856121aquarists
apiarist10412062apiarist
aquaria1638042aquari_a
aquarial1746632aquarial
aquarian1747012aquarian
aquarium1945382aquarium
aquatint1749432aquatint
aquavit1945202aquavi_t
aquavits2043902aquavits
aurist65027252a_u_rist
aviarist11410122aviarist
querist16311132_querist
squarest17338222squarest
squarish2047322squarish
acquaint1945723acqua_int
alarmist1049123a_larmist
ambaris113112163ambaris_
amorist9317643a_morist
annalist8413753annalist
aorist64827873a__orist
aphorist13412513aphorist
apiarists1147883apiarists
aquanaut1744313aquanaut
aquarellist2051943aquarellist
aquarians1845873aquarians
aquariums2043953aquariums
aquas142412613aqua__s_
aquatic1838113aquati_c
aquatics1945893aquatics
aquatints1844033aquatints
arbalist10313333arbalist
arborist10411613arborist
ascaris93613323ascaris_
atavist10311093a_tavist
auris55331533a_u_ris_
aurists74615793a_u_rists
autarkist1345103autarkist
autist64324943a_u_tist
aviarists1246623aviarists
czarist18710223_czarist
diarist8517113_diarist
dualist8614053_dualist
equalise1748213equalise
jurist134616393_ju_rist
naturist8410813natu_rist
ocularist1177323ocularist
purist85525053_pu_rist
quaint15415173_qua_int
quais144618393_qua_is_
quakiest2138583_quakiest
quarks193810913_quarks_
quart144027853_quar__t
quartet162814903_quartet
quarts154715943_quarts_
querists1736543_querists
sitarist8315283sitarist
souaris7312333souaris_
squares163714463squares_
squaring18158633squaring
squarks20417183squarks_
squirish2045113squirish
tourist7313203tou_rist
tsarist7712253_tsarist
tzarist1659103_tzarist
votarist111012163votarist

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.420425454.8
2DLD Change Limit146162667.37619815.9
3Display Results66660.0302200.0
 (SQL Overall)178691667.82622833.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.