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

62 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
socialists124849(None) 
socialises1258251socialises
socialisms1447631socialisms
socialist11411391socialist_
localists11149792loc_alists
racialists1247672racialists
sciolists1147212s_ciolists
serialists10810352serialists
socialise1148732socialis_e
socialised1345942socialised
socialism1348662socialis_m
socialistic1565802socialistic
socialite1148502sociali_te
socialites1247502socialites
sociality1447952sociali_ty
socializes2148402socializes
sodalists1038152so_dalists
specialists1546192specialists
vocalists14108892voc_alists
aerialists1089513aerialists
dialists9411413__dialists
focalises14139953foc_alises
formalists15217613formalists
homilists1456803homi_lists
localises111411463loc_alises
localisms13148733loc_alisms
localist101613963loc_alist_
loyalists12137473lo_yalists
moralists11311093mo_ralists
nominalists1355723nominalists
nonsocialists1563233nonsocialists
oculists1037133_oc_ulists
oralists8611793_o_ralists
racialisms1447223racialisms
racialist11411193racialist_
recitalists1346483recitalists
royalists12178103ro_yalists
sciolisms1346223s_ciolisms
sciolist10410233s_ciolist_
serialises10811553serialises
serialisms12610263serialisms
serialist9715113serialist_
shitlists1245533s_hitlists
socialising1445643socialising
socialities1349283socialities
socialize2048823sociali_ze
socialized2247343socialized
socializer2146023socializer
socializers2243793socializers
socials999633social___s
sociolects1452413sociolects
sociologists1547943sociologists
sodalist9311883so_dalist_
solidarists1253923solidarists
solipsists1252953solipsists
specialises1545973specialises
specialisms1745943specialisms
specialist1448343specialist_
totalists9310743to_talists
vocalises141710323voc_alises
vocalisms16138053voc_alisms
vocalist131512123voc_alist_

Search took 9 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603628.58016387.3
3Display Results62620.063984.1
 (SQL Overall)178691628.79920308.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.