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

223 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
thirties113972(None) 
bhisties1339002bhisties
chitties13310772chitties
dirties83119382_dirties
shirtier1137942shirtier
shirtiest1239332shirtiest
shorties11414582shorties
thirstier1243692thirstier
thirstiest1343972thirstiest
thirteen1143302thirteen
thirteens1243002thirteens
thirtieth1552592thirtieth
thirtieths1661472thirtieths
thistles1198232thistles
thorites11312392thorites
titties73617362t_itties
whirlies14167372whirlies
whirries14136692whirries
whities133113252whi_ties
airtimes1037503_airtimes
amities9317383ami_ties
bedirties1275683bedirties
bhistie1236773bhistie_
birdies104016213_birdies
birkies133712433_birkies
chanties132615803chanties
charities14312743charities
charlies133414233charlies
cherries131812983cherries
chertier1387873chertier
chertiest1438793chertiest
chilies124218303chi_lies
chillies134113483chillies
chintses1337113chintses
chintzes2235973chintzes
chippies17309763chippies
chirpier15276303chirpier
chirpiest16286483chirpiest
chirres123812253chir_res
chitins122713793chi_tins
chivies153412853chi_vies
chivvies1954423chivvies
chortles133611323chortles
christies1449263christies
cities84524853_ci_ties
dainties9312403dainties
dairies84217733dair_ies
deities82621923dei_ties
dhooties1237643dhooties
dhurries1255583dhurries
dirtied93210853_dirtied
dirtier83312093_dirtier
dirtiest93014203_dirtiest
ditties83116983_ditties
fairies103516043fair_ies
ferities111416713ferities
fifties132111083_fifties
flirtier1144893flirtier
flirtiest1236193flirtiest
forties104323863_forties
gaieties9310183gaieties
gharries12318213gharries
ghillies12408663ghillies
girlies83013703_girlies
hardies114923233_hardies
harpies123818323_harpies
harries103525493_harries
hearties11315413hearties
herries104025073_herries
hertzes1938303_hertzes
hickies163614743_hickies
hinnies103615103_hinnies
hippies142813753_hippies
hirees95117293_hir_ees
hires86134343_hir__es
hirples12149643_hirples
hirsles101510073_hirsles
hissies103915823_hissies
hogties112813993_hogties
hotties103016963_hotties
hurdies114015663_hurdies
hurlies103315333_hurlies
hurries103919653_hurries
hurtles103913753_hurtles
kilties113014143_kilties
kirtles11309663_kirtles
kitties113213623_kitties
laities7320343lai_ties
moieties10311263moieties
nifties102612503_nifties
parities10522973parities
parties93230863_parties
philtres1396513philtres
pieties9419223_pieties
pities83828083_pi_ties
purities10316283purities
rarities8316333rarities
shanties113116593shanties
sharpies13411233sharpies
shelties111111383shelties
sherries111812893sherries
shiftier1436343shiftier
shiftiest1537373shiftiest
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
shires95225573shir__es
shirting123213613shirting
shirtings13276603shirtings
shirtless12266413shirtless
shirts94918343shirt__s
shittier1137313shittier
shittiest1238343shittiest
shittims1344423shittims
shortias1148093shortias
shortie10411343shortie_
sixties14310973_sixties
smarties10312873smarties
sorties74126403_sorties
tardies84225863t_ardies
tarries73324263t_arries
tartier74123263t_artier
tartiest82718313t_artiest
tatties74120343t_atties
terries73425633t_erries
theatres11298633theatres
theories11311593theories
therapies1447723therapies
theres96525473ther__es
thermes126214613ther_mes
thermites1438043thermites
thermits1338513thermits
theurgies1343353theurgies
thiamines1446383thiamines
thiamins1346633thiamins
thiazides2242783thiazides
thiazines2144643thiazines
thiazins2045313thiazins
thieves1346903thi_eves
thimbles1536023thimbles
thionines12106973thionines
thionins1177923thionins
thirams1236823thir_ams
thirds10438603thir__ds
thirlages1343763thirlages
thirled11328093thir_led
thirling12248583thirling
thirls95012063thir__ls
thirsted1235213thirsted
thirster1135673thirster
thirsters1235233thirsters
thirstily1542693thirstily
thirstiness1442693thirstiness
thirsting1335283thirsting
thirsts1036243thir_sts
thirty12378403thirt__y
thirtyish1842193thirtyish
thistle10107803thistle_
thistlier1243653thistlier
thistliest1344383thistliest
thither13328103thi_ther
thoraces13118943thoraces
thoraxes1896363thoraxes
thorias102312053thor_ias
thorite10313443thorite_
thornier1135323thornier
thorniest1236483thorniest
thorpes125010353thor_pes
thraves13469713th_raves
threes97117323th_r_ees
thriftier1542853thriftier
thriftiest1643113thriftiest
thrips11299013th_r_ips
thrives134611713th_rives
throes97518673th_r_oes
thrones105715843th_rones
thyroids1546003thyroids
thyrses1335023thyr_ses
tidies74721833t_i_dies
tiptoes939173t_iptoes
tirades8311723t_irades
tires55437493t_ir__es
tithes94720213t_i_thes
titis56023813t_i_ti_s
titles63719923t_i_tles
titres64718933t_i_tres
tittie63213153t_ittie_
tittles73413253t_ittles
tizzies15287893t_izzies
tories65435883t_or_ies
tortes64826053t_ort_es
treaties8316983treaties
tries55742813t__r_ies
trilbies1037693trilbies
trinities9313343trinities
triremes1035523triremes
trusties82712853trusties
turtles72914343t_urtles
tutties73216473t_utties
twenties1137503twenties
twinkies1535983twinkies
twirlier1133513twirlier
twirliest1234503twirliest
twistier1134813twistier
twistiest1235433twistiest
ubieties1046913ubieties
unities72520153uni_ties
verities111418043verities
virtues10338023_virtues
weirdies12255783weirdies
wherries14179023wherries
whimsies1635193whimsies
whinnies14237273whinnies
whirlier14175293whirlier
whirliest15216043whirliest
whirried15154103whirried
whiskies1835953whiskies
whistles14108213whistles
whites123919883whi_t_es
whitier133311063whi_tier
whitiest14259883whi_tiest
whittles1496673whittles
whortles14306743whortles

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.530337152.8
2DLD Change Limit1461622239.15615963.5
3Display Results2232230.0962322.9
 (SQL Overall)1786912239.78218267.3
 
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.