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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
spectates1322881(None) 
pectates122213951_pectates
speciates13229231speciates
spectate12248831spectate_
spectated14236591spectated
pectases122411192_pectases
pectate112214692_pectate_
smectites1344622smectites
speciate12209582speciate_
speciated14207542speciated
spectacles1643912spectacles
spectator1344832spectator
spectators1444532spectators
spectres12268682spect_res
speculates14237902speculates
acetates102013063ace_tates
apostates1149163apostates
aspartates1244673aspartates
asperates11312553aspe_rates
delectates1348193delectates
dictates11311383_dictates
ectases92911673__ectases
edentates1046953edentates
eructates1146953eructates
estates74520183__estates
execrates1839563execrates
gestates93213733_gestates
hectares1338853_hectares
lactates10311223_lactates
metates92720013_me_tates
nictates1039593_nictates
operates10515413ope_rates
pectase112410363_pectase_
pectines121914683_pectines
pectizes21229793_pectizes
peculates132112543_peculates
peltate92013773_peltate_
penates93321603_pe_nates
pentanes10316083_pentanes
petites93820203_pe_tites
picrates122013213_picrates
recrates102420373_recrates
restates83423433_restates
sanitates9611733sanitates
seatmates1157823s_eatmates
secretes10410473s_ecretes
sectaries11312243s_ectaries
sedates83418043s_e_dates
senates73322613s_e_nates
sensates8511143s_ensates
separates11310743separates
septages1168263s_eptages
septate9511873s_eptate_
seriates82620673s_eriates
serrates82617023s_errates
smectite1245773smectite_
spates85028173sp___ates
specialer1344733specialer
specialest1445573specialest
specials1238033specia_ls
specialties1544663specialties
species11314133spec__ies
specifies1647573specifies
speckles16268133spec_kles
spectacle1544083spectacle
spectacled1742543spectacled
spectating1546623spectating
specter113111733spec__ter
specters122811063spect_ers
spectre11297773spect_re_
spectrums1543173spectrums
speculate13239193speculate_
speculated15186613speculated
speltzes1944003spelt_zes
spicate113214193spic_ate_
spicated13309903spic_ated
spiccatos1553253spiccatos
spoliates1138543spoliates
states64337083s___tates
stearates939453stearates
steatites939843steatites
substates111410333substates
supernates12413263supernates
superstates1349553superstates
supertaxes1948083supertaxes
tectites1039993_tectites
testates83615453_testates
tractates1159763tractates
upstates10189643up_states

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.420425454.8
2DLD Change Limit148641896.89321564.1
3Display Results89890.0461934.8
 (SQL Overall)178691897.35924282.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.