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

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

133 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
localist10161396(None) 
localise101511851localise
localism121310011localism
localists11149791localists
loyalist111511131loyalist
vocalist131512121vocalist
focalise131210372focalise
globalist1256762globalist
legalist9512392legalist
locales93715092locales_
localised12167862localised
localises111411462localises
localisms13148732localisms
localite101411542localite
locality13148432locality
localize191410482localize
locals83714502local_s_
loyalest11146722loyalest
loyalism13167572loyalism
loyalists12137472loyalists
moralist10316662moralist
oculist9310882_oculist
oralist7619632_oralist
royalist111311982royalist
socialist11411392socialist
sodalist9311882sodalist
totalist8315582totalist
vocalise131510812vocalise
vocalism15159042vocalism
vocalists14108892vocalists
alist56136783___alist
annalist8413753annalist
arbalist10313333arbalist
atonalist9411833atonalist
backlist16910653backlist
blacklist1746123blacklist
botanist10412033botanist
cabalist12314503cabalist
coaliest10316223co_aliest
cyclist1438853cyc_list
dialist8517763_dialist
dualist8614053_dualist
escapist1246213escapist
fatalist11314973fatalist
finalist113014733finalist
fiscalist1446573fiscalist
focalised15156953focalised
focalises14139953focalises
focalize22139503focalize
formalist141910643formalist
globalise1245153globalise
globalism1445273globalism
globalists1344693globalists
holist94723213ho__list
homilist13410033homilist
idealist9310653idealist
kabalist14410083kabalist
legalise949493legalise
legalism1148583legalism
legalists1047943legalists
libelist10310823libelist
loamiest102310203lo_amiest
lobbyist1543533lobbyist
local74820273local___
locale83915653local__e
localising1345973localising
localites111210433localites
localized21168833localized
localizer20147713localizer
localizes201510543localizes
locally12179723local_ly
localness1145233localness
locates93218813locates_
locating11311503locating
location102113913location
locative1338683locative
locoism1156793loc_oism
locules92812603locules_
loculi8288253loculi__
loculus9296973loculus_
locust85312343loc__ust
loneliest949443loneliest
lookist1139563lo_okist
lordliest1036103lordliest
loudliest1035773loudliest
loveliest1246973loveliest
lowliest11229473lo_wliest
loyalisms14156623loyalisms
lutanist8410273lutanist
medalist11414213medalist
metalist10519353metalist
modelist11310503modelist
moralise10314913moralise
moralism12312363moralism
moralists11311103moralists
muralist10312983muralist
novelist1149453novelist
oculists1037133_oculists
odalisk1265373_odalisk
onanist7314633_onanist
ooralis7312553ooralis_
oralism9513763_oralism
oralists8611803_oralists
oxalis1339223_oxalis_
pluralist1148173pluralist
pollist9816603po_llist
populist1248203populist
racialist11411203racialist
realist73225383_realist
royalism13128473royalism
royalists12178113royalists
ruralist8311703ruralist
scaliest101714393_scaliest
socialise1148733socialise
socialism1348663socialism
socialists1248493socialists
sodalists1038153sodalists
totalise8312503totalise
totalism10311093totalism
totalists9310753totalists
vitalist11313393vitalist
vocalese13165503vocalese
vocalic1446943vocali_c
vocalics1545593vocalics
vocalised15157393vocalised
vocalises141710333vocalises
vocalisms16138053vocalisms
vocality16137933vocality
vocalize221310153vocalize
vocals113811583vocal_s_
votarist111012163votarist
womanist13410433womanist
zocalos1835393zocalos_

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621336.53022383.2
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.01225483.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.