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

48 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
aviarists124661(None) 
apiarists1147881apiarists
aviarist11410111aviarist_
apiarist10412062apiarist_
aquarists1856122aquarists
aviaries1139782aviari_es
diarists9410362_diarists
aerialists1089523aerialists
alarmists1145943a_larmists
alienists946913alienists
amorists10411333a_morists
animalists1258243animalists
animatists1246883animatists
animists103010633ani_mists
annalists949063annalists
aorists74215833a__orists
aphorists1448263aphorists
apiarians1146653apiarians
apiaries10312733apiari_es
aquarist171010083aquarist_
arbalists1148483arbalists
arborists1147453arborists
atavists1137583a_tavists
aurists74615783a__urists
autarkists1443193autarkists
avarices1337183av_arices
avianizes2145553avianizes
aviations12311553aviations
aviatress1242433aviatres_s
aviatrices1543163aviatrices
aviatrixes2042093aviatrixes
clavierists1652643clavierists
czarists1966223_czarists
dialists9411413_dialists
diarist8517113_diarist_
guitarists11134653guitarists
pianists1049013_pianists
plagiarists14154033plagiarists
racialists1247703racialists
satirists958923sati_rists
sitarists949373sitarists
tsarists857303_tsarists
tzarists1755693_tzarists
verists103613673_v_erists
vibists1256483_vi_bists
violists1137663_violists
vitalists1239223_vitalists
votarists1298603votarists

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 Filter1786911486410.423422437.4
2DLD Change Limit148641487.06021054.0
3Display Results48480.0163000.0
 (SQL Overall)178691487.49923828.6
 
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.