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

46 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
unionists94621(None) 
unionises947161unionises
unionisms1145881unionisms
unionist8410351unionist_
fusionists1354472fusionists
reunionists1154562reunionists
unionise847862unionis_e
unionised1046532unionised
unionism1047012unionis_m
unionizes1846112unionizes
agonists9289833_agonists
alienists946913alienists
animists103010633ani_mists
arsonists947413arsonists
canonists1158513canonists
colonists112512503colonists
demonists1248703demonists
disunionists1352873disunionists
fusionisms1543993fusionisms
fusionist1246073fusionist_
gnomists1145473gn_omists
hedonists1346053hedonists
ionises72916433__ionises
ironists839293_ironists
lionises8310313_lionises
luminists1147173lumi_nists
monists93614783__monists
onanists838413on_anists
pianists1049013_pianists
reunionist1056173reunionist_
sciolists1147213sciolists
simonists1146763simonists
unbonnets1143383unbonnets
unionising1145483unionising
unionize1747063unioni_ze
unionized1946673unionized
unionizer1844623unionizer
unionizers1943013unionizers
unions64216753union___s
unitrusts943323unitrusts
unjoints1544433unjo_ints
unknits1135553un_kni_ts
untwists1144623un_twists
urbanists11105483urbanists
utopists1045773u_topists
violists1137663_violists

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 Limit148641467.06321045.0
3Display Results46460.0162875.0
 (SQL Overall)178691467.50223819.1
 
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.