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 “socialistic” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
socialistic156581(None) 
racialistic1554672racialistic
sciolistic1446592s_ciolistic
socialist11411392socialist__
socialists1248492socialist_s
specialistic1854182specialistic
formalistic1854343formalistic
moralistic1446803mo_ralistic
nominalistic1653813nominalistic
socialise1148733socialis__e
socialised1345943socialis_ed
socialises1258253socialis_es
socialising1445643socialising
socialism1348663socialis__m
socialisms1447643socialis_ms
socialite1148503sociali_t_e
socialites1247503sociali_tes
socialities1349293sociali_ties
sociality1447953sociali_t_y
solidaristic1552683solidaristic
solipsistic1552603solipsistic
totalistic1246593to_talistic
animalistic1555294animalistic
annalistic1276444_annalistic
archaistic1745074archa_istic
cabalistic1645714_cabalistic
capitalistic1853754capitalistic
cladistic1445684__cladistic
colonialistic1773184colonialistic
diaristic1247484__diaristic
dualistic1246104__dualistic
eucharistic1863384eucharistic
familistic1754654fami_listic
fatalistic1546714_fatalistic
feudalistic1753404feudalistic
holistic13311264ho___listic
idealistic1344704_idealistic
journalistic2152774journalistic
legalistic1345274_legalistic
localist101613964loc_alist__
localists11149794loc_alist_s
mechanistic2054374mechanistic
mentalistic1555984mentalistic
mutualistic1553344mutualistic
neorealistic1453474neorealistic
nihilistic1554334nihi_listic
nonrealistic1454964nonrealistic
novelistic1544844no_velistic
onanistic1147374_o_nanistic
pacifistic1953824paci_fistic
pianistic1347174__pianistic
pluralistic1554054pluralistic
populistic1644854po_pulistic
pugilistic1553464pugi_listic
racialist11411204racialist__
racialists1247704racialist_s
realistic1148554__realistic
revivalistic2052664revivalistic
ritualistic1354124ritualistic
sadistic1148374s___adistic
scabietic1542894s_c_abietic
scholastic1745864s_cholastic
scholiastic1854104s_choliastic
sciatic11910174s_cia___tic
sciolist10410234s_ciolist__
sciolists1147214s_ciolist_s
scoliotic1345934s_c_oliotic
secularistic1653334secularistic
sensualistic1453034sensualistic
serialist9715114serialist__
serialists10810364serialist_s
shamanistic1863054shamanistic
simplistic1644734s_implistic
sociability1847914sociability
socialistically2273214socialistically
socialization2449104socialization
socialize2048824sociali__ze
socialized2247364sociali_zed
socializer2146024sociali_zer
socializers2243794socializers
socializes2148404sociali_zes
socializing2347344socializing
socials999634social_s___
sociologic1555924sociol_ogic
sodalist9311884so_dalist__
sodalists1038154so_dalist_s
solecistic1444744so_lecistic
soloistic1147334so__loistic
sophistic1647314so__phistic
specialist1448344specialist__
specialists1546204specialist_s
statistic1147134s__tatistic
stochastic1754054stocha__stic
stylistic14116094s__tylistic
surrealistic1452774surrealistic
symbolistic2053544symbolistic
unrealistic1353984unrealistic
vandalistic1753984vandalistic
verbalistic1853864verbalistic
vitalistic1545864_vitalistic
vocalist131512124voc_alist__
vocalists14108894voc_alist_s

Search took 10 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 Filter1786911488190.1731032896.0
2DLD Change Limit1488191029.18616200.6
3Display Results1021020.0462217.4
 (SQL Overall)1786911029.40518999.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.