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

142 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
tweenies1114639(None) 
sweenies11148761sweenies
weenies102915091_weenies
greenies9312672greenies
sheenies111411542sheenies
sweeties11159722sweeties
teenier72611142t_eenier
teeniest82112412t_eeniest
tennies73017972t_ennies
tweedier1253622tweedier
tweediest1344272tweediest
tweedles1234112tweedles
tweener10306832tween_er
tweeners11306242tweeners
tweeness11246402tweeness
tweens9489842tween__s
tweezes19345702twee_zes
twenties1137502twenties
twoonies1155692twoonies
weenie92612022_weenie_
weenier103210802_weenier
weeniest112411212_weeniest
weepies122811742_weepies
wienies102213682_wienies
beanies93821093_beanies
beedies10314203_beedies
bennies93917313_bennies
blennies1056933blennies
creepies1239613creepies
denies74729643__denies
dweebier1442223dweebier
dweebiest1542663dweebiest
freebies1337873freebies
genies75324943__genies
greenie8310123greenie_
greenier938713greenier
greeniest1039033greeniest
heinies102514543_heinies
jennies143511623_jennies
kneesies1245543kneesies
meanies93620743_meanies
meinies92516073_meinies
oogenies9311583oogenies
peeries93623023_peeries
pennies94218813_pennies
peonies93620153_peonies
preemies12512193preemies
redenies9615713redenies
sheenie10159493sheenie_
sheenier11167423sheenier
sheeniest12158363sheeniest
steelies8312553steelies
sweeney13387003sween_ey
sweeneys14294023sweeneys
sweepier1355493sweepier
sweepiest1435683sweepiest
sweetie10157873sweetie_
taenias7311283t_aenias
tawnies102812503t_awnies
techies12513603t_echies
teddies92711283t_eddies
teener64717503t_een_er
teeners74415453t_eeners
teens56227483t_een__s
teensier835573t_eensier
teensiest945833t_eensiest
teepees939263t_eepees
teethes103611653t_eethes
tekkies1035943t_ekkies
tellies73820513t_ellies
tenias64720073t__enias
tennis64015303t_enni_s
tennises82810133t_ennises
tenses64722553t__enses
tenues63816443t__enues
tepefies1346893tepefies
ternes65422903t_ern_es
terries73425633t_erries
tetanies8513553tetanies
theelins1137643theelins
theines104013233thein_es
theories11311593theories
toonies73719883t_oonies
townies103113623t_ownies
trannies8415013trannies
treaties8316983treaties
treenails945563treenails
treens65317873treen__s
trendies9312213trendies
trienes74118413trien_es
trientes82812133trientes
tumefies1345773tumefies
tunnies73614263t_unnies
twankies1535893twankies
tweakier1533143tweakier
tweakiest1634053tweakiest
tweediness1443173tweediness
tweedle1134193tweedle_
tweedled1332833tweedled
tweeds10498433twee__ds
tween84413743tween___
tweenesses1345803tweenesses
tweeny12477003tween__y
tweeted11336583twee_ted
tweeter10288533twee_ter
tweeters11287143tweeters
tweeting12267033tweeting
tweets94210103twee__ts
tweeze18265473twee_ze_
tweezed20274993twee_zed
tweezer19305763twee_zer
tweezers20254383tweezers
tweezing21384113tweezing
twelves1334303tw_elves
twines94717273tw_in_es
twinges11409453tw_inges
twinier1037313tw_inier
twiniest1147153tw_iniest
twinkies1535983twinkies
twoonie1034423twoonie_
twopences1642833twopences
veeries102916893_veeries
wearies103020233_wearies
wedgies123910213_wedgies
weedier113810623_weedier
weediest122311133_weediest
weeklies1534913_weeklies
weened104013733_ween_ed
weening114113973_weening
weens85224053_ween__s
weensier1134243_weensier
weensiest1244753_weensiest
weepie11258793_weepie_
weepier12319273_weepier
weepiest13219473_weepiest
weevils1384683_weevils
weewees1336573_weewees
wellies103719073_wellies
wennier10318603_wennier
wenniest11259593_wenniest
wheelies1437873wheelies
wienie9229973_wienie_

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.423422437.4
2DLD Change Limit1461621426.86021306.4
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.34324334.9
 
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.