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

56 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
antirusts94814(None) 
antirust8411171antirust_
anticults1159372anticults
antitrust946362antitrust_
entrusts847112ent_rusts
intrusts837722int_rusts
unitrusts943322unitrusts
activists1497043activists
altruists945413alt_ruists
anacruses1145523anacruses
anacrusis1143893anacrusis
animists103010633an_imists
animuses1037983an_imuses
antepasts1145523antepasts
antiboss1047273antibos_s
antibuser1145513antibuser
antibusers1244423antibusers
anticult10411683anticult_
antimasks1545733antimasks
antimusic1346263antimusic
antimusics1445533antimusics
antinukes1346143antinukes
antipasti1147063antipasti
antipasto1145393antipasto
antipastos1255153antipastos
antipress1146413antipres_s
antiquate1888033antiquate
antiquates1957463antiquates
antiquers1845793antiquers
antiques1738883antiqu_es
antiquity2145813antiquity
antiracists1357703antiracists
antiriot8414583antiriot_
antistats949233antistats
antitruster1152673antitruster
antitrusters1252013antitrusters
antiviruses1454273antiviruses
antrums969173ant_ru_ms
artists74215593arti__sts
atticists1167943atticists
autists73814853auti__sts
encrusts1045283en_crusts
entrust7410883ent_rust_
incrusts1036253in_crusts
interests9312553interests
intimists1147493intimists
intrust7311493int_rust_
nativists12116253nativists
naturists947513naturists
satirists958923satirists
thrusts10226523__thrusts
trusts64714433__t_rusts
unitrust845563unitrust_
untruss736553unt_rus_s
untrusty1144223unt_rusty
upthrusts1442143upthrusts

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 Filter1786911486410.423422437.4
2DLD Change Limit148641566.39023261.5
3Display Results56560.0301866.7
 (SQL Overall)178691566.84326113.0
 
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.