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

186 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
theatres1129863(None) 
theaters114211901theaters
theatre10358491theatre_
cheaters133613512cheaters
heaters104225222_heaters
sheathes14610192sheathes
theater104014252theat_er
theatric1346142theatric
theatrics1444772theatrics
theres96525472the__res
treaters83615842treaters
treaties8316982treaties
beaters94925043_beaters
bleaters103412323bleaters
breathes134212903breathes
centres93817123_centres
chares115631803ch_a_res
cheapies1539033cheapies
cheated134416343cheat_ed
cheater124816963cheat_er
cheats114519543cheat__s
chelates132713843chelat_es
chevres15379793che_vres
creates95225203creat_es
creatures1138423creatures
eagres74014573__eagres
eaters65535953__eaters
features11310333_features
ghettoes1243493ghettoes
haeres94017033_h_aeres
hares86255543_h_a_res
haters94930403_h_aters
hates86742573_h_at_es
hatred104814333_h_atred
hatreds11307813_h_atreds
headers113819393_headers
headrest122910203_headrest
healers104319463_healers
heapers123616673_heapers
hearer94323643_hea_rer
hearers104319783_hea_rers
hears86737373_hea_r_s
hearse94114273_hea_rse
hearses104414533_hearses
hearted113314023_hearted
hearten102411753_hearten
heartens113010153_heartens
hearths135311073_hearths
hearties11315413_hearties
hearts96218943_hea_rts
heated104525593_heat_ed
heater94828303_heat_er
heathen133410893_heathen
heathens143210153_heathens
heather133914853_heather
heathers143914733_heathers
heaths126316383_heat_hs
heatless113011463_heatless
heats85838403_heat__s
heaumes1237423_heaumes
heavers133717193_heavers
heaves124120303_hea_ves
heavies132713873_heavies
hectares1338853_hectares
hefters134312003_hefters
hektares1535813_hektares
heres86245903_he__res
hertzes1938303_hertzes
ideates8313733ideat_es
matres84522233__matres
metres85121563_me_tres
oleates7417833oleat_es
phenates13611583phenat_es
philtres1396513philtres
phratries1447583phratries
pleaters103613793pleaters
quatres163411933_quatres
reheaters122010273reheaters
sceptres1244993sceptres
seaters74028943_seaters
shares95236413sh_a_res
sheared114516003shea_red
shearer104414683shea_rer
shearers113911323shea_rers
shears93820903shea_r_s
sheathe1348993sheathe_
sheathed1547223sheathed
sheather1458233sheather
sheathers1557553sheathers
sheaths1358753sheat_hs
sheaves134412973shea_ves
sheeters113111863sheeters
shelters113412813shelters
shelties111111383shelties
spectres12268683spectres
sweaters113811063sweaters
tares57456563t__a_res
tarres64723043t__arres
taters64932203t__aters
tates55444983t__at_es
teaches122718353t_eaches
teared75722153t_ea_red
tearer64822903t_ea_rer
tearers75218233t_ea_rers
tears55436463t_ea_r_s
teasers75317243t_easers
teases65426273t_ea_ses
teated74924023t_eat_ed
teatimes1039443t_eatimes
teats55636813t_eat__s
teawares1148083t_eawares
teazles16308923t_eazles
teeters74018303t_eeters
teethes103611653t_eethes
tenters73921103t_enters
tenures7412013t_enures
testees74215913t_estees
testers74124543t_esters
testes65125823t_est_es
tetras63017623t_e_tras
tetris62816293t_e_tris
tetters74320473t_etters
textures1597523t_extures
thairms1244453th_airms
thalers106212263th_alers
thanes94918983th_a_nes
tharms115712243th_a_rms
thatches1637513th_atches
thawers13428483th_awers
thebaines1454963thebaines
thebes115914493the__bes
thecate123210023thecat_e_
thefts12387923theft__s
theines104013233the_ines
theirs94610353the_ir_s
thematics16188113thematics
themes115319253the__mes
thenages12107483thenages
thenars10248523thenar_s
theorem1236273the_orem
theorems1344693the_orems
theories11311593theories
therapies1447723therapies
there87527393the__re_
thermes126214613the_rmes
therms115914873the__rms
thesaurus1252223thesaurus
theses96517973the__ses
thetas93011573the_t_as
thirties1139723thirties
thistles1198233thistles
thrashes1487653thrashes
thraves13469713thra_ves
threaders1365743threaders
threapers1444773threapers
threated1259203threat_ed
threaten1146303threat_en
threatens1254673threatens
threats104311673threat__s
thwarted1533363thwarted
thwarter1433393thwarter
thwarters1542843thwarters
thwarts1345023thwa_rts
titres64718933t__itres
tomatoes1038613tomatoes
treacles1039703treacles
treaders93311843treaders
treadles939703treadles
treasures946633treasures
treated83618703treat_ed
treater74219833treat_er
treatise8311103treatise
treatises9310373treatises
treats64821693treat__s
trestles83012553trestles
tsetses785453tse_tses
tweeters11287143tweeters
twenties1137503twenties
tzetzes1532673tze_tzes
wheaten1336403wheat_en
wheatens1454663wheatens
wheatless1534003wheatless
wheats125013223wheat__s
wheres125917433whe__res
whetters14246653whetters
wreathes14299893wreathes

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 Limit1461621867.30020022.2
3Display Results1861860.0762447.4
 (SQL Overall)1786911867.78222962.1
 
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.