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

101 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
sodalite910959(None) 
sodalites10128691sodalites
sodality12127321sodality
localite101411542localite
modality14117652modality
nodality12127422nodality
socialite1148502socialite
sodalist9311882sodalist
sodalists1038152sodalists
sodalities11138702sodalities
sodamide1245452sodamide
sodomite11136912sodomite
boracite1249193boracite
cobaltite13134333cobaltite
dacite91115883__dacite
egalite8311563_egalite
fayalite1447053fayalite
focalise131210373focalise
focalize22139503focalize
goadlike1435883goadlike
goalie7413163go_ali_e
godlike1387563god_like
halite93624233__halite
hoplite12311073ho_plite
hyalite13229473_hyalite
iodate7313503ioda__te
iolite63221983io__lite
localise101511853localise
localites111210433localites
locality13148433locality
localize191410483localize
modalities13138813modalities
modulate1138593modulate
molality13118363molality
monazite1957083monazite
moralise10314913moralise
morality131110333morality
moralize19313923moralize
nodalities11138583nodalities
nonelite8313613nonelite
nopalito1046063nopalito
novalike1536223novalike
odalisk1265373_odalisk
oolite63319603_o_olite
opaline9412483_opaline
orality101111683_orality
ovality1377593_ovality
oxalate1457623_oxalate
podite93315353pod__ite
podlike14108553pod_like
polite83625073po__lite
rhodolite1344543rhodolite
rodlike1288263rod_like
rolamite1048743rolamite
ruralite848963ruralite
saline65132703s__aline
saltie63422433s__altie
salute64418023s__alute
samite83020603s__amite
sedate73019813seda__te
sedative1238853sedative
sedulity1245843sedulity
sepaline10311343sepaline
sideline91011093sideline
siderite9411363siderite
smaltite1046903s_maltite
soaplike1436903soaplike
socialise1148733socialise
socialites1247503socialites
sociality1447953sociality
socialize2048823socialize
sodaless936113sodaless
sodamides1344653sodamides
sodomites12137193sodomites
sodomize20135253sodomize
solanine8311533solanine
solarise8512543solarise
solarize17511473solarize
solate64526073so__late
solute64016663so__lute
somite84519373so__mite
sonatine8313323sonatine
songlike1336523songlike
sonlike112110713so_nlike
sopite84917713so__pite
soullike1236813soullike
soundalike1552283soundalike
souplike1436333souplike
steatite8310583steatite
stellite839533stellite
stylite10219613s_tylite
sybarite1396543sybarite
toadlike1336143toadlike
tonality1139793tonality
totalise8312503totalise
totality1139373totality
totalize17311523totalize
uralite71714103_uralite
vocalise131510813vocalise
vocality16137933vocality
vocalize221310153vocalize

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621017.56319325.9
3Display Results1011010.0303366.7
 (SQL Overall)1786911018.04622208.7
 
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.