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 “socialism” 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
socialism134866(None) 
socialise1148731socialise
socialisms1447641socialisms
socialist11411391socialist
localism121310012loc_alism
racialism1348332racialism
sciolism1247092s_ciolism
serialism11811982serialism
socialised1345942socialised
socialises1258252socialises
socialists1248492socialists
socialite1148502socialite
sociality1447952sociality
socialize2048822socialize
socials999632social_s_
specialism1646812specialism
vocalism15159042voc_alism
asocials1075683asocial_s_
cocainism1545833cocainism
focalise131210373foc_alise
formalism16218183formalism
localise101511853loc_alise
localisms13148733loc_alisms
localist101613963loc_alist
loyalism13167573lo_yalism
moralism12312363mo_ralism
nominalism1446133nominalism
oralism9513763_o_ralism
racialisms1447223racialisms
racialist11411203racialist
royalism13128473ro_yalism
sciolisms1346223s_ciolisms
sciolist10410233s_ciolist
serialise9912143serialise
serialisms12610273serialisms
serialist9715113serialist
sociables1344963sociables_
social8813333social___
socialising1445643socialising
socialistic1565813socialistic
socialites1247503socialites
socialized2247363socialized
socializer2146023socializer
socializes2148403socializes
socially1338543social_ly
sodalist9311883so_dalist
solarism10810383so_larism
solidarism1354273solidarism
solipsism1343053solipsism
sovietism1442903sovietism
specialise1446603specialise
specialisms1745973specialisms
specialist1448343specialist
totalism10311093to_talism
vocalise131510813voc_alise
vocalisms16138053voc_alisms
vocalist131512123voc_alist

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.453394461.4
2DLD Change Limit148641576.82621775.7
3Display Results57570.0331727.3
 (SQL Overall)178691577.31224438.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.