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

106 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
speciate1220958(None) 
speciated14207541speciated
speciates13229231speciates
spectate12248831spectate
pectate112214692_pectate
seriate73722472s_eriate
special11310302specia_l
specialer1344732specialer
specials1238032specials
specialty1644302specialty
specie10412222speci__e
spectated14236592spectated
spectates13228812spectates
speculate13239192speculate
spicate113214192spic_ate
spoliate1039242spoliate
appreciate1655233appreciate
asperate10312373aspe_rate
associate11116023associate
brecciate1544173brecciate
cruciate1287313cruciate
deciare10710663_deciare
decimate13411123_decimate
depreciate1555083depreciate
deviate11312713_deviate
emaciate1248753emaciate
especial1246293especia_l
execrate1739653execrate
fasciate1347563fasciate
glaciate1168083glaciate
mediate103415213_mediate
operate9615733ope_rate
opiate8513463op__iate
pectase112410363_pectase
pectates122213953_pectates
pectinate1349553_pectinate
peculate122414673_peculate
pedate93117763_pe_date
pelite84323003_peli_te
peltate92013773_peltate
pennate93314033_pennate
petite84320653_peti_te
picrate112014143_picrate
plicate11314513_plicate
recite83625113_reci_te
recrate92621663_recrate
saccate111311763s_accate
satiate7315403s_atiate
secrete9311073s_ecrete
sedate73019813s_e_date
senate63725173s_e_nate
sensate7311893s_ensate
separate10310783separate
septate9511873s_eptate
seriated92717023s_eriated
seriates82620673s_eriates
serrate73017543s_errate
sienite7312713sieni_te
silicate10312623silicate
smectite1245773smectite
sonicate10310933sonicate
spacial1138763spacia_l
spate74731583sp___ate
specialest1445573specialest
specialise1446603specialise
speciality1746333speciality
specialize2347193specialize
specially1647343specially
specialties1544663specialties
speciating1548123speciating
speciation1449393speciation
species11314133speci_es
specific1744703specific
specified1746253specified
specifier1645683specifier
specifies1647573specifies
specify1764993speci_fy
specimen1444423specimen
specious1247483specious
speckle15297553spec_kle
spectacle1544083spectacle
spectator1344833spectator
specter113111733spec__ter
spectre11297773spec_tre
speculated15186613speculated
speculates14237903speculates
speise84614253spe_i_se
spicae104313703spic_a_e
spicated13309903spic_ated
spiccato1463183spiccato
spiculate132210163spiculate
spinate93114813sp_inate
spite75430663sp__i_te
spoliated1246913spoliated
spoliates1138543spoliates
sprite84421773sp_ri_te
stearate839723stearate
stellate8310503stellate
striate74218953s_triate
succinate1346683succinate
sulcate9314423sulc_ate
supernate11313273supernate
suricate10312613suricate
syenite1039773syeni_te
thecate123210023thec_ate
yperite1249893yperi_te

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.406440125.6
2DLD Change Limit1461621067.32619951.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.77822973.9
 
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.