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

112 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
stearates93945(None) 
stearate839721stearate_
iterates81317822ite_rates
separates11310742separates
serrates82617022s_errates
stealages1046042stealages
stearines9311282stearines
steatites939842steatites
steerages1046492steerages
aerates74627493_ae_rates
ameerates1149063ameerates
asperates11312553aspe_rates
berates94126873_be_rates
carates95630613__carates
cerates95428253_ce_rates
deaerates10313643_deaerates
dealates92716683_dealates
derates84028893_de_rates
emeerates1149373emeerates
esterases949633este_rases
execrates1839563execrates
ferrates113013423_ferrates
fumarates1445393fumarates
integrates111010783integrates
iterate71119113ite_rate_
iterated91213823ite_rated
karates115617473__karates
literates91415653lite_rates
operates10515413ope_rates
overrates12414623overrates
recrates102420373_recrates
regrates92618403_regrates
retardates1146433retardates
sarapes94617753s__arapes
saturates9811603saturates
savates10312953s__avates
searches132112903s_earches
seatmates1157823s_eatmates
seawares1139333s_eawares
seawater1136603s_eawater
seawaters1235713s_eawaters
secretes10410473s_ecretes
sedates83418043s_e_dates
senates73322613s_e_nates
sensates8511143s_ensates
separate10310783separate_
separated1237713separated
serapes95218103s_e_rapes
seriates82620673s_eriates
serrate73017543s_errate_
serrated92513433s_errated
shearwater1652263shearwater
shearwaters1751973shearwaters
smearcases1443043smearcases
sororates9410473sororates
speciates13229233speciates
spectates13228813spectates
squamates2045593squamates
stactes91914633st_a_ctes
stagnates1046733stagnates
starches131912913st_arches
stares66038753st_ar__es
starets73515923st_aret_s
stargazes1944083st_argazes
starlets81610083st_arlets
started84217323st_ar_ted
starter73817883st_ar_ter
starters83714773st_ar_ters
startles82111963st_artles
starts65423123st_ar_t_s
starves104614553st_ar_ves
states64337083st___ates
statutes8368893st_atutes
steadies9311123stea_dies
stealage946583stealage_
stealths11104123stea_lths
stearine8311903stearine_
stearins8312143stear_ins
steatite8310583steatite_
steerage946833steerage_
stellate8310503stellate_
stellated1046803stellated
stellites938123stellites
stemwares1444523stemwares
stepdames1443333stepdames
steres63929533ste_r__es
sterlets8169273ste_rlets
sternites9310073sternites
stomates10313343st_omates
storages9311103st_orages
storaxes1536883st_oraxes
strafes104516003st__rafes
strakes114218073st__rakes
stratas73013583st__ratas
straths102711723st__raths
stratus73011733st__ratus
stravages1345843stravages
striates83417083st_riates
styraxes1833493st_yraxes
svarajes1843513s_varajes
swarajes1843743s_warajes
sybarites1465933sybarites
teacakes1435883_teacakes
teammates1345673_teammates
teargases1044803_teargases
teawares1148083_teawares
terraces102712253_terraces
terranes82514433_terranes
terrases82111483_terrases
testates83615453_testates
titrates82314663_titrates
vicarates1487623vicarates

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.423422437.4
2DLD Change Limit1486411127.17320722.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.64223382.8
 
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.