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

102 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
teaselers916584(None) 
teaseler8176571teaseler_
teasellers1043951teasellers
ceaseless1135732ceaseless
teaseled9186792teasele_d
teaseller945192teaseller_
teasels74311312teasel__s
teasers75317242teas__ers
travelers12266772travelers
ashlers10319583__ashlers
baseless1099563_baseless
bevelers13389453be_velers
chiselers1445453chiselers
creaseless1243643creaseless
deadeners1146283deadeners
dealers84118613dea__lers
easeled8159853_easele_d
easels65914553_easel__s
easters75125683_eas_ters
enamelers1144803enamelers
feasters11511563feas_ters
feastless1235043feastless
feelers103814743fe__elers
gaseliers1044923_gaseliers
greaseless1143483greaseless
healers104319463hea__lers
heelers103815623he__elers
jewelers1834713je_welers
kegelers1355163ke_gelers
labelers10249413_labelers
leasers74717843leas__ers
levelers11259323le_velers
measles92412753meas_le_s
measurers1144883measurers
menseless1145203menseless
nestlers8359223ne_stlers
pearlers1039033pea_rlers
peelers93615593pe__elers
ravelers113310863_ravelers
reasoners947113reasoners
reelers73520273re__elers
resellers9299903re_sellers
revelers113414133re_velers
sealers74323553sea__lers
seasoners946263seasoners
senseless945973senseless
stealers83412203stea__lers
tacklers143010773t_acklers
tailers73720183t_a_ilers
talers64628143t_a__lers
tameless10259903t_ameless
tanglers92911973t_anglers
tapeless10218643t_apeless
taperers10269773t_aperers
tasteless935673t_asteless
tasters74225643t_as_ters
tattlers8369693t_attlers
teachers133212393tea_chers
teamakers1544873teamakers
teamsters1135973teamsters
tearers75218233tea__rers
tearless848713tea_rless
teasel63914983teasel___
teaseling1036913teaseling
teaselled1045123teaselled
teaser65421523teas__er_
teases65426273teas__e_s
teazeled18194233teazele_d
teazels16406883teazel__s
teazles16308913tea_zle_s
teemers95012903te__emers
teeners74415453te__eners
teeters74018303te__eters
tellers73717593te__llers
temperers13247023temperers
tenderers10227803tenderers
tenseness947113tenseness
tercelets1144813tercelets
terseness948403terseness
testers74124543te_s_ters
thalers106212263tha__lers
toasters83912723toas_ters
traceless11228643traceless
trailers82912923tra_ilers
trammelers1442513trammelers
tramplers13305883tramplers
trashers113013643tras_hers
traveler11328433traveler_
travellers1364663travellers
trawlers113310203tra_wlers
treadlers1045893trea_dlers
treasurers1043203treasurers
trowelers12105263trowelers
tunnelers953463tunnelers
twaddlers14343613twaddlers
twanglers1363433twanglers
vealers103214293vea__lers
weakeners1644163weakeners
weaseled12175143weasele_d
weasels10468503weasel__s
yeasayers1542023yeasayers
yeastless1234053yeastless

Search took 9 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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411027.90618801.0
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.12521992.7
 
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.