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

229 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
theories1131159(None) 
theorise1137871theorise
theorises1247811theorises
theorizes2147061theorizes
cherries131812972cherries
henries102718282_henries
herries104025072_herries
sherries111812892sherries
terries73425612t_erries
theorbos1343642theorbos
theorem1236262theor_em
theorems1344692theorems
theorised1344922theorised
theorist1149552theorist
theorists1246592theorists
theorize2047062theorize
theorized2245802theorized
theorizer2144862theorizer
theorizers2243332theorizers
theres96525472the_r_es
thermes126214612the_rmes
theurgies1343352theurgies
thorias102312042th_orias
thorites11312392th_orites
thorpes125010352th_orpes
tories65435882t__ories
wherries14179022wherries
abhenries1444503abhenries
aeries64737783_ae_ries
aperies9423203ape_ries
armories10313653armories
berries94423553_berries
calories102919543calories
cheapies1539033cheapies
cheerier1348003cheerier
cheeriest1438213cheeriest
cheerios13317573cheerios
chevies153511443che_vies
chevres15379793chevr_es
chicories1688763chicories
chlorides15289743chlorides
chlorids14299663chlorids
chlorines142512353chlorines
chlorins132612883chlorins
chlorites142311963chlorites
chores114828023ch_or_es
chorines132917253ch_orines
dearies83526273_dearies
decries103319803_decries
derries83124623_derries
dhoolies1246963dhoolies
dhooties1237633dhooties
dhurries1255583dhurries
dories75232363__dories
drearies92313413drearies
emeries91620023eme_ries
etherizes2149313ethe_rizes
ethoxies1845693eth_oxies
eyries93816813__eyries
faeries104118993fae_ries
ferries103521083_ferries
gharries12318203gharries
glories81915913_glories
harries103525493_harries
hearses104414533_hearses
hearties11315413_hearties
heavies132713873_heavies
heinies102514543_heinies
helotries1269563_helotries
heres86245903_he_r_es
heroes94923823_he_roes
heroics122912003_heroics
heroines112916573_heroines
heroins103518013_heroins
heroizes202610983_heroizes
heronries1248483_heronries
herpes115517323_he_rpes
herried113514453_herried
holies94630033_h_olies
homies114524723_h_omies
hoodies113419833_hoodies
hookies144017443_hookies
hordes104921633_h_ordes
horses94729343_h_orses
hurries103919653_hurries
ivories10310713_ivories
jerries143817513_jerries
kerries113317913_kerries
lories64933043__lories
memories121214343memories
peeries93623023_peeries
peonies93620153_peonies
perries93226603_perries
phonies123717513ph_onies
poetries10315583poetries
predries112714383predries
priories10312453priories
queries16315873que_ries
redries83721713_redries
refries104419733_refries
retries74129073_retries
rhetorics1443753rhetorics
savories11311273savories
series64540973_se_ries
serries73925353_serries
sheenies111411543sheenies
shelties111111373shelties
sherifs13299683she_rifs
sherris10168793sherri_s
sherrises12156863sherrises
shores94830403sh_or_es
shorties11414573sh_orties
skerries12168673skerries
stories7324273_stories
taborines11238963taborines
taborins103310213taborins
tarries73324263t_arries
tawdries12136083tawdries
tearier73815613t_earier
teariest82417263t_eariest
techies12513603t_echies
teddies92711283t_eddies
tekkies1035943t_ekkies
tellies73820503t_ellies
tennies73017973t_ennies
tenorites9311083tenorites
terces83921413t_e_rces
ternes65422903t_e_rnes
terrier73414963t_errier
terriers84210813t_erriers
terrines82117523t_errines
territs72714493t_errits
tetris62816293t_etri_s
thearchies1844423thearchies
theatres11298633theatres
theatrics1444773theatrics
thebaines1454943thebaines
thebes115914493the__bes
theelins1137643theelins
theines104013233the_ines
theins95015423the__ins
theirs94610353the__irs
themes115319253the__mes
thenages12107473thenages
theocracies1853843theocracies
theocrats1464683theocrats
theodicies1653343theodicies
theodicy1742773theodicy
theogonies1445033theogonies
theologies141010093theologies
theologs1246153theologs
theonomies1545763theonomies
theorbo1243743theor_bo
theory121098353theor__y
therapies1447713therapies
there87527393the_r_e_
therein102310353the_rein
theriac1239143the_riac
theriacs1336543the_riacs
therian10311293the_rian
therians1138313the_rians
therme115814993the_rme_
thermel12569893the_rmel
thermels13607763the_rmels
thermites1438043thermites
thermits1338493thermits
thermos124610753the_rmos
therms115914873the_r_ms
theroid11313393theroi_d
theses96517973the__ses
thesis94913733the_si_s
thewier1336063the_wier
thewiest14196343the_wiest
thieveries1643473thieveries
thionines12106963thionines
thionins1177923thionins
thirties1139723thirties
tholes94919783th_o_les
thoraces13118933th_oraces
thoraxes1896353th_oraxes
thoria93012883th_ori_a
thoric114314033th_ori_c
thorite10313443th_orite
thorium12208403th_orium
thoriums13166393th_oriums
thorned11479403th_orned
thornier1135323th_ornier
thorniest1236483th_orniest
thorns95314093th_or_ns
thorons104511913th_orons
thorpe113610093th_orpe_
thorps113610893th_or_ps
threes97117323th__rees
threnodies1443923threnodies
threonines1344543threonines
thrips11299013th__rips
thrives134611713th__rives
throes97518673th__roes
thrones105715843thro_nes
thyroids1546003thyroids
thyrses1335013th_yrses
tierces93710453tie_rces
tobies84521013t__obies
todies74223553t__odies
toonies73719883t_oonies
tores55352673t__or_es
torics85118353t__orics
torses64727953t__orses
tortes64826053t__ortes
towies93521193t__owies
treaties8316983treaties
trendies9312213trendies
tries55742813t___ries
tsooris734693tsoori_s
tsores65113663t_sor_es
tsoris63411193t_sori_s
tusheries1246893tushe_ries
tweenies11146393tweenies
twenties1137503twenties
twoonies1155693twoonies
veeries102916883_veeries
wearies103020223_wearies
wheelies1437863wheelies
wheres125917433whe_r_es
wherried15175013wherried
wherves16548053whe_rves
whirries14136693whirries
whoopies16267363whoopies
whores125617103wh_or_es

Search took 10 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.186960704.3
2DLD Change Limit1461622299.14315986.2
3Display Results2292290.0932462.4
 (SQL Overall)1786912299.42218965.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.