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

143 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
localises11141146(None) 
focalises14139951focalises
localise101511851localise_
localised12167861localised
localisms13148731localisms
localists11149791localists
localites111210431localites
localizes201510541localizes
vocalises141710331vocalises
focalise131210372focalise_
focalised15156952focalised
focalizes23159322focalizes
globalises1354592globalises
legalises1038562legalises
locales93715092local__es
localism121310012localis_m
localist101613962localis_t
localite101411542localite_
localities1259732localities
localize191410482localize_
localized21168832localized
localizer20147712localizer
localizers21165252localizers
localness1145232localness
locatives1446562locatives
loyalisms14156622loyalisms
loyalists12137472loyalists
moralises11314002moralises
oxalises1538502_oxalises
socialises1258252socialises
totalises9311782totalises
vocaleses14145322vocaleses
vocalise131510812vocalise_
vocalised15157392vocalised
vocalisms16138052vocalisms
vocalists14108892vocalists
vocalizes231610102vocalizes
alkalises13167483alkalises
anaclises1147863anaclises
botanises1139163botanises
bubalises1346323bubalises
calices114321693__calices
camises114218463__camises
canalises11515493canalises
cocaines121314443coca_ines
delocalizes2345673delocalizes
equalises1847253equalises
finalises122911523finalises
focalize22139503focalize_
focalized24157963focalized
formalises15258993formalises
globalise1245153globalise_
globalised1443213globalised
globalisms1544383globalisms
globalists1344693globalists
globalizes2244643globalizes
goalies8316023go_ali_es
idealises1047783idealises
lapises93513463l__apises
legaleses1044393legaleses
legalise949493legalise_
legalised1145843legalised
legalisms1247163legalisms
legalists1047943legalists
legalizes1938673legalizes
liaises7311053l_ia_ises
lobelines1138563lobelines
locale83915653local__e_
localising1345973localising
locality13148433locali_ty
localnesses1345853localnesses
locals83714503local___s
locates93218813loca__tes
locations112512743locations
locative1338683locative_
locoisms1256143loc_oisms
locules92812603locul__es
logicises1256203logicises
lollies73116923lo_lli_es
longlines1047983longlines
lookalikes1341853lookalikes
lorises73918593lo__rises
lovelies1139893loveli_es
lowlifes1434333lo_wlifes
lowlives1434573lo_wlives
loyalism13167573loyalis_m
loyalist111511133loyalis_t
loyalties1244483loyalties
lychnises1743763lychnises
metalises11315073metalises
mobilises1347513mobilises
moralise10314913moralise_
moralised1239663moralised
moralisms13410293moralisms
moralists11311103moralists
moralizes20312863moralizes
nasalises948113nasalises
normalises12228503normalises
novelises1247373novelises
obelises1039103_obelises
oculists1037133_oculists
odalisks1363503_odalisks
opalines10311423_opalines
oralisms10610973_oralisms
oralists8611803_oralists
penalises11912773penalises
polarises11514073polarises
proclises1339543proc_lises
realises82420183_realises
rocailles1144993rocailles
romanises11311573romanises
royalisms14127263royalisms
royalists12178113royalists
ruralises939123ruralises
secaloses1146913secaloses
socialise1148733socialise_
socialised1345943socialised
socialisms1447643socialisms
socialists1248493socialists
socialites1247503socialites
socializes2148403socializes
sodalists1038153sodalists
sodalites10128693sodalites
solarises9512703solarises
totalise8312503totalise_
totalised1048073totalised
totalisms1139813totalisms
totalists9310753totalists
totalizes18311053totalizes
valises103516263__valises
vitalises12310093vitalises
vocalese13165503vocalese_
vocalics1545593vocali_cs
vocalism15159043vocalis_m
vocalist131512123vocalis_t
vocalities1549393vocalities
vocalize221310153vocalize_
vocalized24178813vocalized
vocalizer23187573vocalizer
vocalizers24185103vocalizers
vocalness1444393vocalness
vocatives1745883vocatives
womanises1448063womanises

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.436409841.7
2DLD Change Limit1486411437.12620859.0
3Display Results1431430.0761881.6
 (SQL Overall)1786911437.63823395.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.