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

105 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
specify176499(None) 
opacify1743652opacify
pacify1667472_pacify
respecify1943132respecify
special11310302special
specie10412222speci_e
species11314132species
specific1744702specific
speechify2251932speechify
spicily1438652spicily
acetify1545003acetify
aerify122810113_aerify
asperity1347223asperity
calcify1735873calcify
cecity1398153_cecity
crucify1744063crucify
deify124112763_de_ify
dulcify1643023dulcify
edify12308563__edify
especial1246293especial
esterify1445623esterify
fancify1834983fancify
opacity1436313opacity
pecky165515093_pec_ky
petrify1536573_petrify
prespecify2252443prespecify
purify14399153_purify
rectify1536453_rectify
reedify1465763reedify
reify114814973_re_ify
repacify1843483repacify
salify12311373s_alify
salsify1334703salsify
sanctify1644493sanctify
saponify1644183saponify
saucily1237913saucily
scarify1537443scarify
scorify1535203scorify
seedily1178583seedily
seif75638733s_e_if_
seifs85019333s_e_ifs
serif84132133s_erif_
serifs94017053s_erifs
sexily1638853s_exily
sherif122915243sherif_
sheriff16287693sheriff
sherifs13299683sherifs
signify1444853signify
silicify1644273silicify
spacey136212533spac_ey
spacial1138763spacial
spacier114011633spacier
spacing123614493spacing
spacy125415623spac__y
spec85821973spec___
specced14266703specced
speccing15306643speccing
specially1647343specially
specials1238033specials
specialty1644303specialty
speciate12209583speciate
specifics1843933specifics
specified1746253specified
specifier1645683specifier
specifies1647573specifies
specifying2144683specifying
specimen1444423specimen
specious1247483specious
speck135115653spec__k
specked16329013specked
specking17359733specking
speckle15297553speckle
specks144312703spec_ks
specs96916673spec__s
specter113111733specter
spectra11275833spectra
spectre11297773spectre
specula11187413specula
speedily1465183speedily
speedy1218410793spe_edy
speil75618643spe_i_l
speils84116223spe_ils
speir75315363spe_i_r
speirs85013233spe_irs
speise84614253spe_ise
speiss84311643spe_iss
spendy124911143spe_ndy
spewing133110453spewing
spicery14499013spicery
spicey134414233spic_ey
spicier115112463spicier
spicing123914533spicing
spicy125417713sp__icy
spiff133616403sp__iff
spiffy17326223sp_iffy
spikily1635873spikily
spiky146014113sp__iky
spiny104921303sp__iny
spiry105017353sp__iry
spliff1438603sp_liff
spoofy14498553sp_oofy
stellify1443883stellify
supercity1648813supercity
verify153110163_verify
zincify2443913zincify

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271056.03022226.7
3Display Results1051050.0333181.8
 (SQL Overall)1786911056.46927622.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.