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

149 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
tweakier153314(None) 
beakier134012162_beakier
creakier14328332creakier
freakier15246482freakier
leakier114010992_leakier
peakier134411442_peakier
sneakier1245142sneakier
streakier1334842streakier
sweatier1147032sweatier
tearier73815612t_earier
tweaked1534402tweak_ed
tweakiest1634052tweakiest
tweaking1635882tweaking
tweedier1253622tweedier
weaker134015442_weak_er
weaklier1534262_weaklier
wearier103613292_wearier
aweather1434263aweather
beadier103513913_beadier
beaker125520693_beak_er
beamier113411943_beamier
bleaker133510533bleak_er
blearier1037333blearier
brakier133812363_brakier
breaker133912923break_er
cakier123115243__cakier
cheekier1735103cheekier
creamier12319063creamier
creasier103210203creasier
croakier14436273croakier
dreamier11287293dreamier
drearier9297923drearier
dweebier1442223dweebier
easier64218463__easier
flakier143910203_flakier
geekier12286393_geekier
gleamier1144913gleamier
greasier9298083greasier
headier113212953_headier
heavier13429423_heavier
jerkier18407273_jerkier
lakier104716273__lakier
leadier83212723_leadier
leafier10329833_leafier
leaker104620073_leak_er
learier73415663_learier
leavier10319993_leavier
mealier93015903_mealier
meatier93214613_meatier
oakier104011393__oakier
peatier94017233_peatier
peckier153910523_peckier
perkier133813123_perkier
peskier13319113_peskier
quakier20239203_quakier
queasier1734473queasier
queazier2642833queazier
readier83117423_readier
reekier113111123_reekier
seamier93114633_seamier
shakier143411153_shakier
sleazier1735123sleazier
sleekier1245573sleekier
smearier1036953smearier
snakier112810003_snakier
sneaker112910453sneak_er
speaker133311213speak_er
squeakier2242903squeakier
steadier937313steadier
steamier1048303steamier
streaker12229483streak_er
streamier1155763streamier
swankier15225503swankier
swearer10349953swea_rer
sweater103712723swea_ter
sweepier1355493sweepier
tackier133712523t_ackier
taker95229003t__ak_er
talkier114011843t_alkier
teacher123714833t_eacher
tearer64822903t_ea_rer
teaser65421523t_ea_ser
techier1269243t_echier
teenier72611143t_eenier
teensier835573teensier
tekkie934203t_ekkie_
tekkies1035943t_ekkies
tentier73815923t_entier
terrier73414963t_errier
testier74015643t_estier
theater104014253thea_ter
thewier1336063the_wier
threadier1354473threadier
towerier1137123towe_rier
treaclier1144153treaclier
treader84113833trea_der
treadler936863treadler
treater74219833trea_ter
treaties8316983treaties
trekker1034733tre_kker
trendier937913trendier
tressier847963tressier
trickier143010233trickier
twanger11327443tw_anger
twangier1254243twangier
twankies1535893twankies
tweak1257753tweak___
tweaks1335963tweak__s
tweaky1634023tweak__y
tweener10306833twe_ener
tweenies11146393tweenies
tweeter10288533twe_eter
tweezer19305763twe_ezer
twenties1137503twenties
twier84713293tw___ier
twiggier1333073twiggier
twinier1037313tw_inier
twinkie1434573twinkie_
twinkies1535983twinkies
twinkler1564073twinkler
twirlier1133513twirlier
twistier1134813twistier
uneasier836963uneasier
vealier102712173_vealier
wackier16369733_wackier
waker125526603_w_ak_er
wanier93920683_w_anier
warier93722893_w_arier
wavier124613083_w_avier
waxier16439903_w_axier
weaken13349603_weak_en
weakener1534913_weakener
weakish17217173_weakish
weaner93816773_wea_ner
wearer94319413_wea_rer
wearied112911823_wearied
wearies103020233_wearies
weather133513223_weather
weaver123916613_wea_ver
webbier1445423_webbier
wedgier12428283_wedgier
weedier113810623_weedier
weenier103210803_weenier
weepier12319273_weepier
wennier10318603_wennier
whackier2044673_whackier
whelkier1833263whelkier
wonkier1437423_wonkier
wreaker143610043wreak_er

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.576310227.4
2DLD Change Limit1461621497.22020244.0
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.